27b.sql

来自「机械工业出版社《SQL Server应用开发实例教程》源代码」· SQL 代码 · 共 6 行

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