--自定义函数
create function fun_result(@score int)
returns varchar(10)
as
begin
declare @result varchar(10)
if @score>=90
set @result='优秀'
else if @score>=80 and @score<90
set @result='良好'
else if @score>=60 and @score<80
set @result='及格'
else
set @result='不及格'
return @result
end
go
create function fun_result(@score int)
returns varchar(10)
as
begin
declare @result varchar(10)
select @result=case when @score>=90 then '优秀'
when @score>=80 and @score<90 then '良好'
when @score>=60 and @score<80 then '及格'
else '不及格' end
return @result
end
go
--执行
select dbo.fun_result(50)
select case stuSex when '1' then '男'
when '2' then '女'
else '其他' end as '性别',COUNT(*) as '数量'
from student group by stuSex
--找出empId有2个以上的数据
select empId from Tab_Extra_Salary group by empId having COUNT(*)>1
