Scribd
Upload
6 views2 pages

Understanding SQL SELECT Statement

The SQL SELECT statement is used to select data from a database. It retrieves data from one or more tables and constructs a result table from the rows and columns of the tables. The SELECT statement syntax includes specifying columns to select from the table and using wildcards to select all columns. An example demonstrates selecting specific columns or all columns from the Customers table in the Northwind sample database.

Uploaded by

Hardik Patel
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
6 views2 pages

Understanding SQL SELECT Statement

The SQL SELECT statement is used to select data from a database. It retrieves data from one or more tables and constructs a result table from the rows and columns of the tables. The SELECT statement syntax includes specifying columns to select from the table and using wildcards to select all columns. An example demonstrates selecting specific columns or all columns from the Customers table in the Northwind sample database.

Uploaded by

Hardik Patel
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

SQL SELECT Statement

Previous
Next Chapter

The SELECT statement is used to select data from a database.

The SQL SELECT Statement


The SELECT statement is used to select data from a database.
The result is stored in a result table, called the result-set.

SQL SELECT Syntax


SELECT column_name,column_name
FROM table_name;

and
SELECT * FROM table_name;

Demo Database
In this tutorial we will use the well-known Northwind sample database.
Below is a selection from the "Customers" table:

CustomerID

CustomerName

ContactName

Address

Alfreds Futterkiste

Maria Anders

Obere Str. 57

Ana Trujillo Emparedados y helados

Ana Trujillo

Avda. de la Constitucin

Antonio Moreno Taquera

Antonio Moreno

Mataderos 2312

Around the Horn

Thomas Hardy

120 Hanover Sq.

Berglunds snabbkp

Christina Berglund

Berguvsvgen 8

SELECT Column Example


The following SQL statement selects the "CustomerName" and "City" columns
from the "Customers" table:

Example
SELECT CustomerName,City FROM Customers;
Try it yourself

SELECT * Example
The following SQL statement selects all the columns from the "Customers"
table:

Example
SELECT * FROM Customers;
Try it yourself

Navigation in a Result-set
Most database software systems allow navigation in the result-set with
programming functions, like: Move-To-First-Record, Get-Record-Content,
Move-To-Next-Record, etc.
Programming functions like these are not a part of this tutorial. To learn
about accessing data with function calls, please visit our ASP tutorialor
our PHP tutorial.

You might also like