sql server 2000转mysql后，sql语句的修改对照

来源：互联网发布：怎样注册一级域名编辑：程序博客网时间：2024/05/02 09:37

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