查询语法:select * from table
去重:
SELECT DISTINCT 列名 FROM 表名
模糊查询:
SELECT * FROM student WHERE name LIKE '%友';
条件查询:
select ProductID,ProductName,Price from Product where Price>5.0 And Price<=10.0
别名查询:
select '产品编号'as ProductID,ProductName,Pricefrom Product where Price>5.0
查询列表查询:
select SaleID,SaleName,Sex,Birthday,HireDate,Address form Seller where SaleID IN('S01','S02',S07)
top排序查询:
select top 6 * from Product order by price desc (asc(低—>高) desc(高->低))
null查询:
select * from pur