[thelist] SQL SELECT Question

Luther, Ron Ron.Luther at hp.com
Tue Dec 10 16:19:01 CST 2002


Hi Burhan,


How about a "SELECT DISTINCT column_name FROM table_name"?

That should return all of the unique values in that column - which
might be what they are looking for.


HTH,

RonL.

-----Original Message-----
From: Burhan Khalid [mailto:burhankhalid at members.evolt.org]

      The question was, how do you write a select statement so it
      returns only a list of all values in one column.



More information about the thelist mailing list