Mysql
1.表中的第二大id号
SELECT MAX(vcid) FROM msdtb1701 WHERE vcid <(SELECT MAX(vcid) FROM msdtb1701)
SELECT MAX(vcid) FROM msdtb1701 WHERE vcid NOT IN (SELECT MAX(vcid) FROM msdtb1701)
2.表中的第二大id号及其user
SELECT vcuser ,vcid FROM msdtb1701 WHERE vcid=(SELECT MAX(vcid) FROM msdtb1701 WHERE vcid NOT IN (SELECT MAX(vcid) FROM msdtb1701))
3.表中第三大id号
SELECT MAX(vcid) FROM msdtb1701 WHERE vcid< (SELECT MAX(vcid) FROM msdtb1701 WHERE vcid NOT IN (SELECT MAX(vcid) FROM msdtb1701))
4.表中前三大的id号及其user
SELECT vcid,vcuser FROM msdtb1701 ORDER BY vcid DESC LIMIT 3 (依照此数值调整限制输出行数)
Sql Server
1.表中第N大数值
select TOP N * from tablename where。。。。。
ORACLE
1.表中第N大的数值
SELECT * FROM TABLE1 WHERE ROWNUM<=N