27b.sql

机械工业出版社《SQL Server应用开发实例教程》源代码

select ygxm,sfz,gz 
from employee
where ygbh between 2 and 5
order by sfz
compute sum(gz),avg(gz) by sfz