2007 Oracle数据库基础教程 14.2.1数据查询基础 口基本语法: SELECT [ALL DISTINCT]column_nameL, expression.] FROM table1_namel table2_name, view_name TWHERE condition] [GROUP BY column_namel column_name2.] [HAVING group_condition] TORDER BY column name2 [ASCIDESCILcolumn name2.li2007 Oracle 数据库基础教程 14.2.1数据查询基础 基本语法: SELECT [ALL|DISTINCT]column_name[,expression…] FROM table1_name[,table2_name,view_name,…] [WHERE condition] [GROUP BY column_name1[,column_name2,…] [HAVING group_condition]] [ORDER BY column_name2 [ASC|DESC][,column_name2,…]];