Question

sql如何查询语句大全？

Answer 1

SELECT * FROM TWS2F14CCC260D71 WHERE 地类='1999资源清查有林地'

1、Alter table LOANS add [备注说明] varchar(20)。

2、Select 出版社,KCSL as 库存量,总价/KCSL as 平均单价 From  (Select 出版社,count(索书号) as KCSL,sum(价格) as 总价 from BOOKS Group by 出版社)  As 库存表 Order by 库存量 Desc。

3、Select Left(借书证号,2) as 年级,Count(*) as 人数 from BORROWER Order by 年级。

4、Select 出版社 from BOOK Where 价格>200 group by 出版社。

5、Select 借书证号,Count(图书登记号) As 借书数量 from LOANS Group by 借书证号 having Count(图书登记号) >5 order by 借书证号 Desc。