Thursday, October 17, 2013

SQL: Formatting SQL Statement

Key components of Data Manipulation Language (DML) SQL statement's format:

SELECT
INSERT
UPDATE
DELETE
SELECT
INSERT INTO
VALUES
UPDATE
SET
WHERE
DELETE
FROM
WHERE
FROM
INSERT INTO
SELECT
FROM
WHERE


WHERE
AND
OR



GROUP BY



HAVING
AND
OR



ORDER BY




Hope this helped!

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.