sql server 2000转mysql后，sql语句的修改对照_sql2000 mysql 语句转换工具-优快云博客

本文链接：https://blog.youkuaiyun.com/sd_lichangyou/article/details/5689542

本文对比了SQL Server 2000与MySQL中实现获取特定数量记录的TOP语句的不同写法，展示了如何在两种数据库系统中按不同字段进行排序并限制返回结果的数量。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

主要针对top语句

sql server 2000中的语句

select top 4 * from (
select top 4 * from (
    select top 4 * from (select * from GOODS) my_table order by GOODS_NO asc,GOODS_ID asc
                      ) my_table1 order by GOODS_NO desc,GOODS_ID desc
                    ) my_table2 order by GOODS_NO asc,GOODS_ID asc

mysql中的语句

select * from (
select * from (
    select * from (select * from GOODS) my_table order by GOODS_NO asc,GOODS_ID asc limit 0,4
                      ) my_table1 order by GOODS_NO desc,GOODS_ID desc limit 0,4
                    ) my_table2 order by GOODS_NO asc,GOODS_ID asc limit 0,4

sql server 2000中的语句

select top 4 * from (
   select top 4 * from (
     select top 4 * from (select * from GOODS) my_table order by GOODS_ID desc
                        ) my_table1 order by GOODS_ID asc
                    ) my_table2 order by GOODS_ID desc

mysql中的语句

select * from (
   select * from (
     select * from (select * from GOODS) my_table order by GOODS_ID desc limit 0,4
                        ) my_table1 order by GOODS_ID asc limit 0,4
                    ) my_table2 order by GOODS_ID desc limit 0,4