sqlsever中使用的 select top n在mysql 语句中如何更改

 

string sqlSelect = "select top(3) ROW_NUMBER() over(order by UserTime) as Num,* from " + "UserScore1";

改后

 string sqlSelect = "select a.UserName,a.UserTime as Num from userscore1 a ORDER BY a.UserTime LIMIT 3";

用的Limit