select user_name,news_text
from user_news_site
where news_date =
(
select user_name,min(news_date)
from user_news_site A,user_news_site B
where A.user_name = B.user_name
group by user_name
)
from user_news_site
where news_date =
(
select user_name,min(news_date)
from user_news_site A,user_news_site B
where A.user_name = B.user_name
group by user_name
)
CREATE TABLE #TEMP
(id BIGINT,
news_class NVARCHAR(50),
news_name NVARCHAR(50),
news_text NVARCHAR(50),
news_date DATETIME,
[user_name] NVARCHAR(50),
click INT)INSERT #TEMP
SELECT 5,'a','a','a','2008-01-01','a',1
UNION SELECT 6,'b','b','b','2008-02-02','b',2
UNION SELECT 7, 'c', 'c','c','2008-03-03','c',3
UNION SELECT 8,'d','d','d','2008-04-05','b',4
UNION SELECT 10,'d','d','ff','2008-05-05' ,'a',3
UNION SELECT 11,'a','d','fdfd','2008-05-05','b',4 SELECT * FROM #TEMP A
WHERE news_date=(SELECT TOP 1 news_date FROM #TEMP WHERE A.[user_name]=[user_name] ORDER BY news_date DESC)
/*
id news_class news_name news_text news_date user_name click
----------------------------------------------------------------------------------------------------
7 c c c 2008-03-03 00:00:00.000 c 3
10 d d ff 2008-05-05 00:00:00.000 a 3
11 a d fdfd 2008-05-05 00:00:00.000 b 4(3 行受影响)
*/