按条件分类！
如图哈！
[解决办法]
select a.姓名,a.成绩,
(case when a.成绩>=60
'及格'
else
'不及格' end ) as 分类
from yourtable a
[解决办法]
if object_id('a6') is not null
drop table a6
go
create table a6
(
NAME NVARCHAR(20),
grade int
)
go
insert into a6
select '小同1',70 union all
select '小同2',65 union all
select '小同3',20 union all
select '小同4',12 union all
select '小同5',80
go
select *,
(case when grade >=60 then '及格' else '不及格' end)[分类] from a6
--引用 ZaoLianBuXiQi
if object_id('a6') is not null
drop table a6
go
create table a6
(
NAME NVARCHAR(20),
grade int
)
go
insert into a6
select '小同1',70 union all
select '小同2',65 union all
select '小同3',20 union all
select '小同4',12 union all
select '小同5',80
----------------------------------
Select *,Case
When grade < 60 then '不及格'
When grade >60 And grade <80 then '及格'
else '优秀' end as fg
From a6
------------用计算列
Alter table a6
add fg as (Case When grade< 60 then '不及格'
else Case when grade < 80 then '及格'
else '优秀' end
end )
Select *
From a6
----------------
小同170及格
小同265及格
小同320不及格
小同412不及格
小同580优秀
select 姓名,
成绩,
case when 成绩>=80 then '优秀'
when 成绩<80 and 成绩>=60 then '及格'
when 成绩<60 then '不及格' end '分类'
from [表名]
