sqlserver自定義函數

--自定義函數
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