WITH TIES clause requires an ORDER BY clause.
TOC
Collapse the table of content
Expand the table of content

WITH TIES clause requires an ORDER BY clause.

The query does not conform to SQL syntax, because it uses the WITH TIES clause without an attendant ORDER BY clause. Either remove the WITH TIES clause or add an ORDER BY clause.

Community Additions

ADD
Show:
© 2016 Microsoft