sql server 2000转mysql后，sql语句的修改对照_sqlserver转mysql sql语句-CSDN博客

本文链接：https://blog.csdn.net/sd_lichangyou/article/details/5689542

主要针对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