select name from student where Score=(select min(Score) from student)
select * from students where Score = (select min(Score) from students)
select * from students where Score=(select min(Score) from students)
select top 1 Score,name from 表order by Score
declare @t table(Score int,name varchar(10)) insert into @t select 10,'aa' insert into @t select 30,'ba' insert into @t select 140,'acc' insert into @t select 30,'dd' insert into @t select 60,'ee'select * from @t a where not exists(select 1 from @t where score<a.score)
select top 1 Score,name from 表order by Score 这个比较妙...偶稀饭
最简单的代码即可: SELECT TOP 1 name FROM student ORDER BY Score ASC
where Score=(select min(Score) from student)
where Score = (select min(Score) from students)
where Score=(select min(Score) from students)
insert into @t select 10,'aa'
insert into @t select 30,'ba'
insert into @t select 140,'acc'
insert into @t select 30,'dd'
insert into @t select 60,'ee'select * from @t a where not exists(select 1 from @t where score<a.score)
这个比较妙...偶稀饭
SELECT TOP 1 name FROM student ORDER BY Score ASC