??????????????SQL??????????????????????????????????????????????????????????????????????????????????????????? ?????????????????????????????????Щ?????SQL ??????Щ??????????
?????????дSQL??????????JOOQ???????SQL???????????б???????????????????????SQL??????????????????????
?????????ù????????????SQL?????
??????????????SQL????δ????????????????????
????????????????SQL?????
????????????????SELECT ??????? DML ??佫?????????????????????????????…
????1??SQL????????????
?????????????????????????????????????????????????y???????????????????????????????????Щ??????
????SELECT first_name?? last_name FROM employees WHERE salary > 100000
???????????????????????????????????????????????????????????н???
??????????????????????
??????????????????????????????????????????????????????????????????????????磺“???????????????????????????????????????????????????????????”?????????????д洢??????д??????????????ú????????????
????????Щ???????????????????????????????????????????
????2??SQL??????“?????”
????????????????????????????SQL???????????????????з??????????????￡?

 

SELECT [DISTINCT]
FROM
WHERE
GROUP BY
HAVING
UNION
ORDER BY

??????????????????г?????SQL?????????????????????????????????????￡?

 

FROM
WHERE
GROUP BY
HAVING
SELECT
DISTINCT
UNION
ORDER BY

??????????????????
????1?????????FROM????????SELECT?????????????????????????У???????Щ??????в?????
????2??SELECT???????????????????У???????????FROM??GROUP BY?????????????????????????WHERE???????????????SELECT????е????????????????е??
????SELECT A.x + A.y AS z
????FROM A
????WHERE z = 10 -- z is not available here!