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
 General SQL Server Forums
 New to SQL Server Programming
 creating a master list

Author  Topic 

rico16135
Starting Member

11 Posts

Posted - 2008-04-16 : 16:26:47
How can I create a master list of a particular column, in other words is there a SELECT query I can do that would bring back one of every type of? here's an example: calls table -- bring back one of every kind of call_descr thx for any help.

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-04-16 : 16:59:16
select distinct col1 from table1



E 12°55'05.25"
N 56°04'39.16"
Go to Top of Page
   

- Advertisement -