对比MYSQL与SQL SERVER2005的逻辑查询处理

对比MYSQL与SQL SERVER2005的逻辑查询处理

MYSQL的逻辑处理查询如下：

(8)SELECT (9) DISTINCT

(1)FROM

(3) JOIN

(2)ON

(4)WHERE

(5)GROUP BY

(6)WITH{CUBE|ROLLUP}

(7)HAVING

(10)ORDER BY

(11)limit

 

 

SQL SERVER2005的逻辑处理查询如下：

(8)SELECT (9) DISTINCT (11) TOP

(1)FROM

(3) JOIN

(2)ON

(4)WHERE

(5)GROUP BY

(6)WITH{CUBE|ROLLUP}

(7)HAVING

(10)ORDER BY

 

在逻辑上在处理逻辑上处理显示的数据行数量不一样，MYSQL用LIMIT,SQL SERVER2005 用TOP。