select top 10 * from tabel a where a.id=(select top 29 id from table order by id desc)
select top 10 * from tablename where time < '9:30' order by time desc
如何取最后一条呢? 比如ID 20的?那ID20是最后一条吗?select top 1 * from tablename order by time desc
select top 10 * from tabel a where a.id=(select top 29 id from table order by id desc) 这个取不到吗?
select top id from table1 where time!>'9:30' order by time desc
select top 10 id from table1 where time!>'9:30' order by time desc
bz586() ( ) 信誉:100 Blog 2006-11-18 09:15:23 得分: 0
就是10条内的最后一条。
====================================10条内的最后一条,是第十条吗?SELECT top 1 * from (select top 10 * from tablename)t order by id desc
就是10条内的最后一条? select top 1 * from (select top 10 id from table1 where time!>'9:30' order by time desc)a order by time asc--注意排序asc,desc
如何取最后一条呢? select top 1 * from tb order by time desc
select top 1 * from (select top 10 * from tablename where time < '9:30' order by time desc )t order by time
谢谢! 顺便问一下:在存储过程中把10 作为参数传入, 提示出错:服务器: 消息 170,级别 15,状态 1,过程 re,行 16 第 16 行: '@last' 附近有语法错误。select @starttime=min(time) from ( select top @last * from m where time<@endtime order by time desc )a
where time < '9:30'
order by time desc
比如ID 20的?那ID20是最后一条吗?select top 1 * from tablename order by time desc
这个取不到吗?
就是10条内的最后一条。
====================================10条内的最后一条,是第十条吗?SELECT top 1 * from
(select top 10 * from tablename)t
order by id desc
select top 1 * from (select top 10 id from table1 where time!>'9:30' order by time desc)a order by time asc--注意排序asc,desc
select top 1 * from tb order by time desc
(select top 10 * from tablename
where time < '9:30'
order by time desc
)t order by time
顺便问一下:在存储过程中把10 作为参数传入,
提示出错:服务器: 消息 170,级别 15,状态 1,过程 re,行 16
第 16 行: '@last' 附近有语法错误。select @starttime=min(time) from (
select
top @last * from m where
time<@endtime
order by time desc
)a