The SQL SELECT Statement
The SELECT statement is used to select data from a table. The tabular result is stored in a result table (called the result-set).
Syntax
SELECT column_name(s)
FROM table_name
|
Note: SQL statements are not case sensitive. SELECT is the same as select.
SQL SELECT Example
To select the content of columns named "LastName" and "FirstName", from the database table called "Persons", use a SELECT statement like this:
SELECT LastName,FirstName FROM Persons
|
The database table "Persons":
LastName
|
FirstName
|
Address
|
City
|
Hansen
|
Ola
|
Timoteivn 10
|
Sandnes
|
Svendson
|
Tove
|
Borgvn 23
|
Sandnes
|
Pettersen
|
Kari
|
Storgt 20
|
Stavanger
|
The result
LastName
|
FirstName
|
Hansen
|
Ola
|
Svendson
|
Tove
|
Pettersen
|
Kari
|
Select All Columns
To select all columns from the "Persons" table, use a * symbol instead of column names, like this:
Result
LastName
|
FirstName
|
Address
|
City
|
Hansen
|
Ola
|
Timoteivn 10
|
Sandnes
|
Svendson
|
Tove
|
Borgvn 23
|
Sandnes
|
Pettersen
|
Kari
|
Storgt 20
|
Stavanger
|
The Result Set
The result from a SQL query is stored in a result-set. Most database software systems allow navigation of 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 ADO tutorial.
Semicolon after SQL Statements?
Semicolon is the standard way to separate each SQL statement in database systems that allow more than one SQL statement to be executed in the same call to the server.
Some SQL tutorials end each SQL statement with a semicolon. Is this necessary? We are using MS Access and SQL Server 2000 and we do not have to put a semicolon after each SQL statement, but some database programs force you to use it.
分享到:
相关推荐
SQL 语法 SQL select SQL distinct SQL where SQL AND & OR SQL Order By SQL insert SQL update SQL delete SQL 高级 SQL Top SQL Like SQL 通配符 SQL In SQL Between SQL Aliases SQL Join SQL ...
sql语法大全 基于sqlserver数据库
常用SQL语法技巧常用SQL语法技巧常用SQL语法技巧常用SQL语法技巧常用SQL语法技巧
SQL语法手册 Select 用途 从指定表中取出指定的列的数据 语法:SELECT column_name(s) FROM table_name 解释: 从数据库中选取资料列,并允许从一或多个资料表中,选取一或多个资料列或资料行。SELECT 陈述式的...
SQL语法大全中文版SQL语法大全中文版SQL语法大全中文版SQL语法大全中文版SQL语法大全中文版SQL语法大全中文版SQL语法大全中文版SQL语法大全中文版
Hive_Sql语法详述,平时工作中遇到的问题,用于Hadoop平台的数据挖掘。
SqlParser C++实现的SQL语法解释器,忘了在哪找到的,方便大家学习,直接贴上来了
适合教学使用的SQL语法课件,内容相对精炼。
ORACLE和SQL语法区别归纳 对于新手有帮助
Oracle与SQLServer的SQL语法差异,用简单易懂的语言和实例对Oracle和Sql Server语法之间的差异进行了对比分析,更加适用于入门的人
SQL语法教材.pdf SQL 语法说明 一、 利用 SELECT 指令选取数据 1. SELECT 语法基本架构 2. 选取全部资料 3. 指定字段 4. 选取不重复的数据 5. 衍生字段 6. 数据排序 7. 资料分组 8. 加上选择条件 9. 使用万用字符 ...
SQL语法参考手册,TXT文档 DB2 提供了关连式资料库的查询语言 SQL (Structured Query Language),是一种非常口语化、既易学又易懂的语法。此一语言几乎是每个资料库系统都必须提供的,用以表示关连式的操作,...
oracle sql 语法大全 oracle sql 语法大全
sql语法大全中文版sql语法大全中文版sql语法大全中文版sql语法大全中文版sql语法大全中文版sql语法大全中文版
SQL语法手册.rar SQL语法手册.rar SQL语法手册.rar SQL语法手册.rar
SQL语法大全 1. ASP与Access数据库连接: 2. ASP与SQL数据库连接: 3.整合性的查询: 1、等值连接:在连接条件中使用等于号(=)运算符比较被连接列的列值,其查询结果中列出被连接 表中的所有列,包括其中的重复...
Sql语法帮助手册_Sql语法帮助文档.rar
详细讲解SQL语法,值得收藏! 详细讲解SQL语法,值得收藏! 详细讲解SQL语法,值得收藏!
SQL语法测验SQL语法测验SQL语法测验SQL语法测验SQL语法测验SQL语法测验SQL语法测验SQL语法测验SQL语法测验