[thelist] SQL SELECT Question

[Rob Whitener]

SELECT SomeColumn FROM SomeTable

-----Original Message-----
From: Burhan Khalid [mailto:burhankhalid at members.evolt.org]
Sent: Tuesday, December 10, 2002 10:26 AM
To: thelist at lists.evolt.org
Subject: [thelist] SQL SELECT Question


Hello All,

      Recently I was asked a SQL question from a person new to SQL
      that had me stumped -- because I had never thought of it before.
      The question was, how do you write a select statement so it
      returns only a list of all values in one column. The first thing
      that came to my mind is the "SELECT * FROM [table]", but that
      returns a list of all records, from all columns.

      I then thought that if I gave a conditional that's always true,
      it might work, ie. "SELECT someColumn FROM someTable WHERE 1=1",
      but was told that it didn't work.

      We eventually decided to go with SELECT *, and dump the data
      that we didn't need, but the question has been bothering me for
      a while. Anyone have any clues?


Regards,
--
*---------------*
| Burhan Khalid |
*---------------*---------------------------*
| Email : burhankhalid[at]members.evolt.org |
| Web   : members.evolt.org/burhankhalid    |
*-------------------------------------------*



--
* * Please support the community that supports you.  * *
http://evolt.org/help_support_evolt/

For unsubscribe and other options, including the Tip Harvester
and archives of thelist go to: http://lists.evolt.org
Workers of the Web, evolt !