mysql中取得记录集中某行记录的行号

参考代码如下：

SELECT * FROM ( SELECT wno , name , score, utime , (@rowno:=@rowno+1) AS rowno FROM member ,(SELECT (@rowno:=0)) b  ORDER BY score DESC , utime ASC ) a WHERE wno='123'

另外C#中使用带参数的语句请注意连接串参数