求条语句 我知道查询最后一条记录应该这么写:select top 1 name from student order by shijian desc但是如果我要查询倒数第二条记录怎么写呢?请教各位 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 select top 1 name from student order by shijian descwhere shijian !=(selelct top 1 shijian from student order by shijian desc) SELECT TOP 1 NAME FROM (select top 2 name,shijian from student order by shijian desc)T ORDER BY shijian select top 1 *from(select top 2 * from tb order by shijian desc)torder by shijian --orselect top 1 name from(select top 2 * from student order by shijian desc)t order by shijian select top 1 *from(select top 2 * from tb order by shijian desc)torder by shijian select top 1 name from (select top 2 * from student order by shijian desc)a order by shijian 数据库字段求和问题 select 1 where ''=0 为什么返回1 数据库访问权限问题 如何用一句SQL语句解决下面的这个问题? sql客户端数据库别名有何作用? 数据插入的问题 求助关于SQL语句的查询 sql自定义函数代码,实现在对数据库数据的加密和解密??? 数据库安装的问题 表转换 表名前面的N是什么意思 统计发帖数?
where shijian !=(selelct top 1 shijian from student order by shijian desc)
(select top 2 name,shijian from student order by shijian desc)T ORDER BY shijian
select top 1 *
from(select top 2 * from tb order by shijian desc)t
order by shijian
select top 1 name from(
select top 2 * from student order by shijian desc
)t order by shijian
from(select top 2 * from tb order by shijian desc)t
order by shijian
(select top 2 * from student order by shijian desc)
a order by shijian