摘要：SELECT SELECT [columns] FROM [tables] WHERE [search_condition] ORDER BY [order_expression ASC | DESC] 例： 取得前面的100个数据 SELECT TOP 100 * FROM Sales ORDER BY ord_date DESC Select * from store w... 阅读全文

摘要：1.在查询结果中显示列名： a.用as关键字：select name as '姓名' from students order by age b.直接表示：select name '姓名' from students order by age 2.精确查找: a.用in限定范围：select * from students where native in ('湖南', '四川') ... 阅读全文