Examples:
Given the following table: This
SQL statement: Would produce the following results: Related Resources:
Elsewhere on the Web:
Definition:
The SELECT statement in SQL is the primary
mechanism for retrieving information from a relational database.
Related Terms
• Database
• Query
• SQL
Members
ID
LastName
Age
1
Smith
25
2
Jones
42
3
Reynolds
36
SELECT LastName
FROM Members
WHERE Age>30
LastName
Jones
Reynolds
Structured
Query Language
Visit our Structured Query Language subject page for more on this topic.
Getting Started
with SQL
The Web Developer's Virtual Library provides a very readable introduction to the
Structured Query Language.
<Back to Last Page> <Full Glossary>
SELECT
<Back to Last Page> <Full Glossary>
Explore Databases
Must Reads
About.com Special Features
Stay connected and entertained with reviews on tips on the latest HDTVs, cellphones and more. More >
Easy ways to connect two computers for networking purposes. More >
©2009 About.com, a part of The New York Times Company.
All rights reserved.