Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Other Forums
 MS Access
 Distinct Query

Author  Topic 

irehman
Starting Member

22 Posts

Posted - 2002-05-21 : 12:05:24
Table Name = T1
Column 1 = C1
Column 2 = C2

I am trying to get distinct column1. Please let me know the correct snyntax.

robvolk
Most Valuable Yak

15732 Posts

Posted - 2002-05-21 : 12:24:38
SELECT DISTINCT C1 FROM T1

Wish I could take credit for that, but you pretty much wrote it yourself!

Go to Top of Page
   

- Advertisement -