DQL:Data Query Language SELECT 数据查询语言
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 ] ]
例子：找出emp表中员工号为007的员工的工资
SELECT t.sal
FROM emp t
WHERE t.ID =007