Select TOP 1 * from 表 Where 关键字 Not In(Select TOP 2 关键字 from 表 Order By 关键字)Order By 关键字
判断当前记录在数据库里是第几条记录(按照时间,房间号排序)
SELECT COUNT(payid) AS Expr1
FROM payusers
WHERE (paytime <
(SELECT paytime
FROM payusers
WHERE payid = 73)) AND (dt2_id = 14)
转载于:https://www.cnblogs.com/yzxchoice/archive/2006/08/25/486324.html