SQL server中等同于mysql 中limit的语句

SELECT *
FROM (SELECT TOP 20 *
        FROM (SELECT TOP 20 *
                FROM iwear_cube
                WHERE deleted = 0
                ORDER BY createdate DESC) DERIVEDTBL
        ORDER BY createdate) DERIVEDTBL
ORDER BY createdate DESC

引用通告地址: http://www.hanliang.name/trackback.php?tbID=125&extra=14736c
标签: SQL