Sql Server取出数据中任意行的数据

总共13行数据，取出第6－10行的数据

SELECT *
FROM (SELECT TOP 5 *
        FROM (SELECT TOP 10 *
                FROM apple
                ORDER BY id) a
        ORDER BY id DESC) b
ORDER BY id


随机取5行数据
SELECT  top 5 *
FROM apple
ORDER BY NEWID()