求一条SQL语句..

11 |

selectid,UserName,Title,AddDateFrom newswhere ID in (select top 2 max(id) From news group by UserName order By AddDate desc)...

千问 | 2011-3-8 14:45:56 | 显示全部楼层

额这个非常简单啊selectdistinct top 2 username from news order by adddate desc...

千问 | 2011-3-8 14:45:56 | 显示全部楼层

select top 2 username from (select username,max(adddate)newdatefrom news group byusername) aorder bynewdate desc...

千问 | 2011-3-8 14:45:56 | 显示全部楼层

oracle库select * from (select * from news order by adddate) where rownum < 2...

千问 | 2011-3-8 14:45:56 | 显示全部楼层

select disticttop 2username from news order byadddate...

主题	0 回帖	4882万积分

Rank: 8 Rank: 8

热门排行