MSSQL:
Select top 20 username from
(Select username,max(logindate) logindate from TableName
Group by username) ss
Order by logindate desc;Oracle:
Select username from
(Select username,max(logindate) logindate from TableName
Group by username) ss
Where rownum <= 20
Order by logindate desc
Select top 20 username from
(Select username,max(logindate) logindate from TableName
Group by username) ss
Order by logindate desc;Oracle:
Select username from
(Select username,max(logindate) logindate from TableName
Group by username) ss
Where rownum <= 20
Order by logindate desc
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货