RelationalDBDesign
SiteMap
Business Rules
Cursors Views
Database Creation
SQL Monitoring
Database Web Apps
Data Manipulation
Access Features
Tables Queries
Basic Queries
«Prev
Database Web Applications
Database Concepts
Table Structures
SQL
Data Binding
Basic Queries
SQL Select Statement
SQL Where Clause
Sort Results Orderby
Modify Records Update
SQL Insert Statement
Delete Table Row
SQL Capability Conclusion
Intro Data Access
Binding DataBound DesignTime Controls
Create Commandobject Toquery Database
Creating Recordset Designtimecontrol
Displaydata Using Boundcontrols
Add Navigationcontrols Tomove Withinrecordset
Selecting Records Basedon Userinput
Scripting with Recordsets
Defensive Programming Handling Errors
Displaydata Inwebapplication Conclusion
Modifying Data
Updating Database Records
Data Types Databases
Direct Database Access
SQL SELECT Statement Syntax
SELECT ARGUMENTS FROM TABLE
The SELECT statement defines the query and specifies the columns of data to get from the specified table.
The
SELECT
statement begins the query definition.
The
arguments
specify the columns of data to retrieve.
FROM
specifies the table.
The
table
is the table name.