- 论坛徽章:
- 0
|
问题说明如下:
有一张学生成绩表,有两个字段姓名和成绩,表结构以及数据如下
create table studentScore
(
[NAME] [varchar](300) Not NULL,
[SCORE] [int] not NULL
)
insert into studentScore(NAME,SCORE)
select '安梦琪',30
union
select '白跃伟',65
union
select '蔡翔一',60
union
select '陈名宇',76
union
select '陈鹏嵘',67
union
select '陈品汝',50
union
select '陈恬然',44
union
select '陈臻毅',70
union
select '戴金鑫',40
union
select '戴骊诺',78
union
select '傅斌豪',76
union
select '胡舒绮',67
union
select '黄群栩',69
union
select '季宛怡',50
union
select '季新楠',78
union
select '金睿妍',50
union
select '郎梓含',100
union
select '李 扬',90
union
select '李周蜜',40
union
select '林慧依',88
union
select '林莉雅',36
union
select '林芊彤',80
union
select '林奕伶',76
union
select '林哲好',56
union
select '刘俊余',34
union
select '刘展硕',87
union
select '麻菽宸',80
现在要求用一条SQL实现如下结果:
安梦琪 30
刘俊余 34
林莉雅 36
李周蜜 戴金鑫 40
陈恬然 44
陈品汝 季宛怡 金睿妍 50
林哲好 56
... ... |
|