1、单查询内,SELECT、FROM、WHERE、GROUP、ORDER各一行 SELECT XXX FROM XXX WHERE 1=1 AND XX GROUP BY XXXX ORDER BY XX ------------------ 包括SELECT\WHERE\GROUP BY 2、过长的行要分行 SELECT XXXXXXXXXXXXX,XXXXcXXXXXXXXXXX,XXXXXXXXXcXXXXXXXXXXXXXX,XXXXXXXXXXXXXXXXX,XXXXXXXXX,XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX select T1.AAA AS `SDFSS` ,T2.BBB AS `ERWOEN` ,T2.BBB AS `ERWOEN` ,T2.BBB AS `ERWOEN` ,CASE WHEN T2.XXXXXXXXXXXX BETWEEN XXXXXXXXXXXX AND XXXXXXXXXX THEN CASE WHEN XXXXXXXXXX THEN XXXXXXXXXX ELSE XXXXXXXX END ELSE 0 END AS `ERWOEN` 3、缩进 SELECT FROM (SELECT XXXX SERNWOEINRSDFOWNE SDFNWOEIR' ASDFWONEINRRWOEIRNSFNWER) T INNER JOIN (SDFNNOWEINRIOWNEEROIN) ON SDFNOWOERNOWINERON SELECT FROM ( SELECT XXX FROM XXX WHERE 1=1 AND XX GROUP BY XXXX ORDER BY XX ) T INNER JOIN ( SELECT XXX FROM XXX WHERE 1=1 AND XX GROUP BY XXXX ORDER BY XX ) T2 ON T1.XXXX=T2.XXXXX where (datac.INMCU_1 = '-' or datac.INMCU_1 in ( SELECT DISTINCT CIMCU FROM ( SELECT XXX FROM XXX WHERE 1=1 AND XX GROUP BY XXXX ORDER BY XX ) A LEFT JOIN F0006 B ON A.CIMCU = B.MCMCU WHERE A.CIGLPO = 'Y' ) 优化美观
时间: 2023-04-08 07:05:11 浏览: 96
1、单查询内,SELECT、FROM、WHERE、GROUP、ORDER各一行:
SELECT XXX
FROM XXX
WHERE 1=1
AND XX
GROUP BY XXXX
ORDER BY XX
2、过长的行要分行:
SELECT XXXXXXXXXXXXX,
XXXXcXXXXXXXXXXX,
XXXXXXXXXcXXXXXXXXXXXXXX,
XXXXXXXXXXXXXXXX,
XXXXX,
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
SELECT T1.AAA AS `SDFSS`,
T2.BBB AS `ERWOEN`,
T2.BBB AS `ERWOEN`,
T2.BBB AS `ERWOEN`,
CASE WHEN T2.XXXXXXXXXXXX BETWEEN XXXXXXXXXXXX AND XXXXXXXXXX
THEN CASE WHEN XXXXXXXXXX THEN XXXXXXXXXX ELSE XXXXXXXX END
ELSE 0
END AS `ERWOEN`
3、缩进:
SELECT
FROM (
SELECT XXXX
SERNWOEINRSDFOWNE
SDFNWOEIR' ASDFWONEINRRWOEIRNSFNWER
) T
INNER JOIN (
SDFNNOWEINRIOWNEEROIN
) ON SDFNOWOERNOWINERON
SELECT
FROM (
SELECT XXX
FROM XXX
WHERE 1=1
AND XX
GROUP BY XXXX
ORDER BY XX
) T
INNER JOIN (
SELECT XXX
FROM XXX
WHERE 1=1
AND XX
GROUP BY XXXX
ORDER BY XX
) T2
ON T1.XXXX=T2.XXXXX
WHERE (
datac.INMCU_1 = '-'
OR datac.INMCU_1 IN (
SELECT DISTINCT CIMCU
FROM (
SELECT XXX
FROM XXX
WHERE 1=1
AND XX
GROUP BY XXXX
ORDER BY XX
) A
LEFT JOIN F0006 B
ON A.CIMCU = B.MCMCU
WHERE A.CIGLPO = 'Y'
)
)
希望能对您有所帮助。