Msg 102, Level 15, State 1, Line 44 Incorrect syntax near ')'.

Question

Question by Rajesh007 · Jan 04 at 03:30 PM · sql-server

Msg 102, Level 15, State 1, Line 44 Incorrect syntax near ')'.

WITH cte AS (SELECT id, first_name, last_name,manager_id,emp_code,department_id,ROW_NUMBER() OVER (PARTITION BY first_name, last_name ORDER BY first_name, last_name) as row_num FROM EMPLOYEESOFCOMMERZTECH) Msg 102, Level 15, State 1, Line 44 Incorrect syntax near )

1

10 |1200 characters needed characters left characters exceeded

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 1 · 2021-01-04T15:35:26Z

Best Answer

Answer by Kev Riley · Jan 04 at 03:35 PM

If you declare a CTE but not use it, then this is the error you get

1 Show 1 · Share

10 |1200 characters needed characters left characters exceeded

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Rajesh007 · Jan 04 at 03:41 PM 0

Share

Thanks Kev Riley

Msg 102, Level 15, State 1, Line 44 Incorrect syntax near ')'.

1 Reply

Your answer

Follow this Question

Related Questions