sql 查询问题 SELECT * FROM replybbs T WHERE NOT EXISTS(SELECT 1 FROM replybbs WHERE BBSID=T.BBSIDAND createtime >T. createtime ) 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 DECLARE @TB TABLE([id] INT, [bbsid] INT, [author] VARCHAR(5), [createtime] DATETIME)INSERT @TB SELECT 1, 1, 'name1', '2005-11-02 22:16:06' UNION ALL SELECT 2, 1, 'name2', '2005-11-03 09:59:05' UNION ALL SELECT 3, 1, 'name3', '2005-11-12 13:17:43' UNION ALL SELECT 4, 1, 'name4', '2005-11-14 17:10:24' UNION ALL SELECT 5, 4, 'name5', '2005-11-16 14:15:04' UNION ALL SELECT 6, 4, 'name1', '2005-11-22 22:39:57' UNION ALL SELECT 7, 5, 'name3', '2005-12-02 17:02:59' UNION ALL SELECT 8, 7, 'name1', '2005-12-08 09:16:44' UNION ALL SELECT 9, 7, 'name4', '2005-12-12 11:54:39' UNION ALL SELECT 10, 7, 'name3', '2005-12-12 11:55:07' UNION ALL SELECT 11, 8, 'name1', '2005-12-12 11:56:07'SELECT bbsid,author,createtimeFROM @TB AS TWHERE NOT EXISTS(SELECT 1 FROM @TB WHERE [bbsid]=T.[bbsid] AND [createtime]>T.[createtime])/*bbsid author createtime----------- ------ -----------------------1 name4 2005-11-14 17:10:24.0004 name1 2005-11-22 22:39:57.0005 name3 2005-12-02 17:02:59.0007 name3 2005-12-12 11:55:07.0008 name1 2005-12-12 11:56:07.000*/ 请教多表外连接的问题 如何用SELECT输入多条记录, 不是查询! 提个简单的问题 求一存贮过程 请救急sql基本问题 很急!跪下求助! 在sql server中如何把一字段内容在的空格或加车去掉?-在线等 top新手问题!!! 数据库阻塞, 服务器端怎么优化 散分,纪念工作半年 求一SQL语句 sql查找提取字符串
INSERT @TB
SELECT 1, 1, 'name1', '2005-11-02 22:16:06' UNION ALL
SELECT 2, 1, 'name2', '2005-11-03 09:59:05' UNION ALL
SELECT 3, 1, 'name3', '2005-11-12 13:17:43' UNION ALL
SELECT 4, 1, 'name4', '2005-11-14 17:10:24' UNION ALL
SELECT 5, 4, 'name5', '2005-11-16 14:15:04' UNION ALL
SELECT 6, 4, 'name1', '2005-11-22 22:39:57' UNION ALL
SELECT 7, 5, 'name3', '2005-12-02 17:02:59' UNION ALL
SELECT 8, 7, 'name1', '2005-12-08 09:16:44' UNION ALL
SELECT 9, 7, 'name4', '2005-12-12 11:54:39' UNION ALL
SELECT 10, 7, 'name3', '2005-12-12 11:55:07' UNION ALL
SELECT 11, 8, 'name1', '2005-12-12 11:56:07'SELECT bbsid,author,createtime
FROM @TB AS T
WHERE NOT EXISTS(SELECT 1 FROM @TB WHERE [bbsid]=T.[bbsid] AND [createtime]>T.[createtime])
/*
bbsid author createtime
----------- ------ -----------------------
1 name4 2005-11-14 17:10:24.000
4 name1 2005-11-22 22:39:57.000
5 name3 2005-12-02 17:02:59.000
7 name3 2005-12-12 11:55:07.000
8 name1 2005-12-12 11:56:07.000
*/