I am in search of someone who can help me in my SQL query. I am having problem with my DISTINCT. My query is as below:
But the above query gives me the message as "Incorrect syntax near ')". Can anyone help me figure out how to use DISTINCT in SQL?Code:SELECT DISTINCT(empId) FROM (SELECT empId FROM Employee WHERE Name LIKE 'R%')
Bookmarks