Trouble with Select Distinct() FROM Sub Select

[dlarkin77]

Hi,

I'm using SQL Server 2005 and I'm having a bit of trouble with something that seems like it should be pretty simple.

I have a table with 2 fields - AccountNo and Name. Neither field has to be unique.

I want to get the number of distinct AccountNo where the Name begins with the letter a.

SELECT DISTINCT(AccountNo) FROM (SELECT AccountNo FROM Customers WHERE Name LIKE 'a%')

The query fails and I get the message "Incorrect syntax near ')".

I'm sure I'm doing something pretty stupid somewhere. Can anyone help me figure out what it it?

Thanks,

dlarkin77

[Shuja Ali]

There is no need for the sub-query. You could just do this

SELECT Distinct AccountNo FROM Customers WHERE Name LIKE 'a%'

[dlarkin77]

I'm embarrassed at how simple that is .

Thanks very much Shuja Ali.

I would rate your post but I have to spread some reputation around before I can so I'll get you sometime later.