您所在位置：主题：自学数据库问[1]
yclz
[专家分：1520] 发布于 2005-07-31 23:58:00
SQL语句对换行要求严格吗?
如:
SELECT JNO
FROM J
WHERE JNO NOT IN
(SELECT JNO
FROM SPJ
WHERE PNO IN('P3','P5'))
ORDER BY JNO;
可不可心写成:
SELECT JNO FROM J WHERE JNO NOT IN
(SELECT JNO
FROM SPJ
WHERE PNO IN('P3','P5'))
ORDER BY JNO;
除了美学和可读性??
还有SQL语句区分大小写吗?
