或: select way1S,way2S,way1,way2,stu_ID, way1R,way2R from student as a where stu_ID='123456' and not exists (select * from student where stu_ID=a.stu_ID and time>a.time)
select way1S,way2S,way1,way2,stu_ID, way1R,way2R from student where time=(select max(time) from student where stu_ID='123456') 这样就可以了。
MINDNET(风) ( ) select way1S,way2S,way1,way2,stu_ID, way1R,way2R from student where time=(select max(time) from student where stu_ID='123456') 这样就可以了。----------------------- 当time在不同的stu_ID有重复值时,有误~~
我不是帅哥,也不是太丑,^_^ select top 1 * from student where stu_ID='123456' order by time desc
同意这个:select top 1 way1S,way2S,way1,way2,stu_ID, way1R,way2R from student where stu_ID='123456' order by time desc ^_^
我同意 select top 1 way1S,way2S,way1,way2,stu_ID,way1R,way2R from student where stu_ID='123456' order by time desc 这种说法
select top 1 way1S,way2S,way1,way2,stu_ID,way1R,way2R from student where stu_ID='123456' order by time desc
select way1S,way2S,way1,way2,stu_ID,
way1R,way2R from student as a
where stu_ID='123456' and not exists (select * from student where stu_ID=a.stu_ID and time>a.time)
way1R,way2R from student
where time=(select max(time) from student where stu_ID='123456')
这样就可以了。
way1R,way2R from student
where time=(select max(time) from student where stu_ID='123456')
这样就可以了。-----------------------
当time在不同的stu_ID有重复值时,有误~~
select top 1 * from student
where stu_ID='123456'
order by time desc
way1R,way2R from student
where stu_ID='123456'
order by time desc
^_^
select top 1 way1S,way2S,way1,way2,stu_ID,way1R,way2R
from student
where stu_ID='123456'
order by time desc
这种说法
from student
where stu_ID='123456'
order by time desc