SQL when then 练习题

最新推荐文章于 2023-12-27 14:00:42 发布

原创最新推荐文章于 2023-12-27 14:00:42 发布 · 177 阅读

0 ·

本内容遵循CC 4.0 BY-SA版权协议

收录于

SQL学习笔记专栏收录该内容

19 篇文章

订阅专栏

本文将通过一系列的练习题，深入探讨SQL中CASE语句的WHEN THEN用法，帮助读者掌握如何在查询中进行条件判断和数据转换。

   create table TblScore
   (
   tScoreId int identity primary key not null,
   tSid int  not null,
   tEnglish int null,
   tMath int null,
   )
   go
   insert into TblScore values(1,56,100)
      insert into TblScore values(2,88,92)
	     insert into TblScore values(3,90,72)
		    insert into TblScore values(4,99,78)
			   insert into TblScore values(5,90,83)
			      insert into TblScore values(6,null,80)
			      insert into TblScore values(7,90,68)
				  insert into TblScore values(8,90,51)
				insert into TblScore values(9,40,17)
			insert into TblScore values(10,95,70)
select * from TblScore

select *,
		是否及格=case
		when [tenglish]>60 and [tmath]>60 then '及格'
		else '不及格'
		end
from TblScore