求一条sql 表结构为 ID,userID,cont,time查询当前用户组A(101,102,103)中,每个用户最新的300条记录。 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 select * from table where ID in (101,102,103) order by time limit 0,300; select t.* from tb t where time in (select top 300 time from tb where userid = t.userid order by time desc) SELECT B.* FROM TB A CROSS APPLY(SELECT TOP(300)* FROM TB B WHERE A.userID=B.userID ORDER BY TIME DESC) B select t.* from tb t CROSS APPLY (select top 300 [time] from tb where userid = t.userid order by [time] desc)WHERE userid IN (101,102,103)小猜一下 select t.* from tb t CROSS APPLY (select top 300 [time] from tb where userid = t.userid order by [time] desc)TTWHERE userid IN (101,102,103)晕!!! 谢谢各位,不过开始忘记说明了,我现在用的是mysql 由于mysql中没有top,而使用limit会报错 select t.* from tb t where (select count(*) from tb where userid = t.userid and id>=t.id)<=300 sql语句导入导出大全 (由于刚才帖子没发好,重发下) 这个存储过程哪里错了 这条SQL语句存在什么问题 急呀 !!!!!!!!!各位大虾帮帮忙呀 。。。。。。。 SQL2005 远程连接 错误18456 state28000 数据库附加错误! sql server2005无法被访问 存储过程写事务 sql server 中numeric数据类型的7.5和7.500不相等吗? 可不可以写在Insert前发生的触发器 查询昨天下午16:00-18:00的数据 sql 2008 连结 sql2000的问题
select t.* from tb t where time in (select top 300 time from tb where userid = t.userid order by time desc)
from tb t
CROSS APPLY (select top 300 [time] from tb where userid = t.userid order by [time] desc)
WHERE userid IN (101,102,103)
小猜一下
from tb t
CROSS APPLY (select top 300 [time] from tb where userid = t.userid order by [time] desc)TT
WHERE userid IN (101,102,103)晕!!!
where (select count(*) from tb where userid = t.userid and id>=t.id)<=300