请教一个查询 请教一个查询如何查出每个用户最后发布的信息? 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 select *from title twhere adddate=( select max(adddate) from title where userid=t.userid) select *from tb twhere not exists(select 1 from tb where [userid]=t.[userid] and adddate>t.adddate) SELECT * FROM ITEMS T1 WHERE NOT EXISTS(SELECT 1 FROM ITEMS T2 WHERE T2.USERID=T1.USERID AND T2.ADDDATE>T1.ADDDATE) select * from from items as xwhere x.adddate>= all( select adddate from items y where x.userId=y.useID) select userid,max(adddate) from group by userid select a.*from items a,(select userid,max(adddate) adddate from items group by userid) bwhere a.userid=b.userid and a.adddate=b.adddate select * from table where adddate in(select max(adddate) as LastTime from table group by userid) SELECT * FROM tb tWHERE id = ( SELECT TOP 1 id FROM tb WHERE userid = t.userid ORDER BY adddate DESC ) 表自连接就可以实现了。select [id],[userid],title,adddatefrom tb twhere not exists(select 1 from tb where [userid]=t.[userid] and adddate>t.adddate) SELECT * FROM tb tWHERE id = ( SELECT TOP 1 id FROM tb WHERE userid = t.userid ORDER BY adddate DESC ) select * from tb twhere not exists(select 1 from tb where [userid]=t.[userid] and adddate>t.adddate) 请教数据分组统计问题,谢谢 DataTable设置主键问题 菜鸟查询问题,高手请进。 这样的结果能不能直接查出来 mysql的移植到arm+linux上碰到的问题 帮我看看这个问题该怎么办 请高手解释区别!! 这个语句怎么写 这个sql语句怎么不能用?是不是update语句不支持in关键字?谢谢! 高分相求,一个*.dat数据文件的导入问题:) 动态获得当前数据库名,并使用的sql脚本如何写 请求高手帮我解答
from title t
where adddate=(
select max(adddate)
from title
where userid=t.userid)
from tb t
where not exists(select 1 from tb where [userid]=t.[userid] and adddate>t.adddate)
SELECT 1 FROM ITEMS T2 WHERE T2.USERID=T1.USERID AND T2.ADDDATE>T1.ADDDATE
)
where x.adddate>= all( select adddate from items y where x.userId=y.useID)
select userid,max(adddate) from group by userid
from items a,(select userid,max(adddate) adddate from items group by userid) b
where a.userid=b.userid and a.adddate=b.adddate
select max(adddate) as LastTime from table group by userid
)
SELECT *
FROM tb t
WHERE id = (
SELECT TOP 1 id
FROM tb
WHERE userid = t.userid
ORDER BY adddate DESC
)
select [id],[userid],title,adddate
from tb t
where
not exists(select 1 from tb where [userid]=t.[userid] and adddate>t.adddate)
FROM tb t
WHERE id = (
SELECT TOP 1 id
FROM tb
WHERE userid = t.userid
ORDER BY adddate DESC
)
where not exists
(select 1 from tb where [userid]=t.[userid] and adddate>t.adddate)