1.
CREATE TABLE t( id INT IDENTITY, [name] NVARCHAR(10), pid INT)INSERT tSELECT N'张三', 0 UNION ALLSELECT N'李四', 0 UNION ALLSELECT N'王五', 2GO--SQL:select * from t order by pid descselect top 5 WITH TIES * from t order by pid DESCselect top 5 * from t order by pid desc
待整理。。
