oracle 常用SQL语法手册

Select

用途:

 从指定表中取出指定的列的数据

语法:

SELECT column_name(s) FROM table_name

解释:

从数据库中选取资料列,并允许从一或多个资料表中,选取一或多个资料列或资料行。SELECT 陈述式的完整语法相当复杂,但主要子句可摘要为:

SELECT select_list
[ INTO new_table ]
FROM table_source
[ WHERE search_condition ]
[ GROUP BY group_by_expression ]
[ HAVING search_condition ]
[ ORDER BY order_expression [ ASC | DESC ] ]

 

posted @ 2017-08-17 16:56  小猫钓鱼吃鱼  阅读(135)  评论(0编辑  收藏  举报