1. Computing & Technology
SELECT
<Back to Last Page> <Full Glossary>

Related Terms
Database
Query
SQL

Definition: The SELECT statement in SQL is the primary mechanism for retrieving information from a relational database.

Examples: Given the following table:

Members

ID LastName Age
1 Smith 25
2 Jones 42
3 Reynolds 36

This SQL statement:

SELECT LastName
FROM Members
WHERE Age>30

Would produce the following results:

LastName
Jones
Reynolds

Related Resources:

Structured Query Language
Visit our Structured Query Language subject page for more on this topic.

Elsewhere on the Web:

Getting Started with SQL
The Web Developer's Virtual Library provides a very readable introduction to the Structured Query Language.

Subscribe to the Newsletter
Name
Email


<Back to Last Page> <Full Glossary>

Discuss in my forum

©2012 About.com. All rights reserved.

A part of The New York Times Company.