Select (SQL): Meaning (information, definition, explanation, facts)

A SELECT statement in SQL returns a result set of records from one of more tables.

Examples

Table 'T' Query Result
C1 C2
1 a
2 b
Select * from T
C1 C2
1 a
2 b
C1 C2
1 a
2 b
Select C1 from T
C1
1
2
C1 C2
1 a
2 b
Select * from T where C1=1
C1 C2
1 a

Given a table T, the query Select * from T will result in all the elements of all the rows of the table being shown.

With the same table, the query Select C1 from T will result in the elements from the column C1 of all the rows of the table being shown.

With the same table, the query Select * from T where C1=1 will result in all the elements of all the rows where the value of column C1 is '1' being shown.

See:

Find more facts
 
Further reference
Remember what Select (SQL) means:
Other sources
Search for Select (SQL) information on:  amazon.com
Your reference for information, definition
http://explanation-guide.info/meaning/Select-(SQL).html
SELECT (SQL)
Licensing information:
This article uses material from Wikipedia (credits) and is made available under the terms of the GNU FDL (copy).
Image licensing information is accessible by clicking the image.

Welcome, guest!
You are not logged in
ID:
Password:

Social bookmarks
del.icio.us
Furl
Yahoo! My Web


Book search
Current topics
» NEW! "In the News"

» St. Patrick's Day
» Qashqai
» Bird flu, H5N1
» Space Shuttle
» Winter Sport, Ski
» Sports events
» World Cup 2006
» Anagram

Recent searches
 » earth wind fire
 » siegfried sassoon
 » c. z. guest
 » lincoln aviator
 » golden eagle
 » writers contemporary
 » fisher (animal)
 » panzer iii
 » dynamic systems development method
 » effective input noise temperature