+ -
当前位置:首页 → 问答吧 → 装了oracle-xe-client后系统启动不了呀......

装了oracle-xe-client后系统启动不了呀......

时间:2011-12-04

来源:互联网

他们两个SQL都实现相同的功能,他们有区别嘛?
代码:
SELECT DISTINCT c. *
FROM category c
JOIN goods g ON g.cid_top = c.cid
AND g.list_end_time > NOW( )
AND g.list_start_time < NOW( )
AND c.parent_cid =0
LIMIT 0 , 30

代码:
SELECT DISTINCT c. *
FROM category c
JOIN goods g ON g.cid_top = c.cid
WHERE g.list_end_time > NOW( )
AND g.list_start_time < NOW( )
AND c.parent_cid =0
LIMIT 0 , 30

作者: hellojinjie   发布时间: 2011-12-04

一般我们在开发中都用哪种形式的?

作者: hellojinjie   发布时间: 2011-12-04