Crash SQL Course

Hi guys, I need a crash course on SQL, I know the basics but I need a consice tutorial on advanced SQL syntax, if you guys know of any you could recommend, I'd really appreciate it. Thanks in advance.

GROUPY BY column1 [HAVING SUM(column2) operator1 value1];

INSERT INTO table1 (column1, column2) VALUES (value1, value2);

{LEFT} / {INNER} / {RIGHT} JOIN table1 ON column1 operator1 column2;

ORDER BY column1;

SELECT [DISTINCT] {column1, column2} / {column1,SUM(column2)} / {*} INTO table1 [IN database1] FROM table1 [WHERE column3 operator1 value1] [AND column4 operator2 value2 / OR column5 operator3 value3];

TRUNCATE TABLE table1;

UNION [ALL];

UPDATE table1 SET column1 = value1 WHERE column2 operator1 value2;

Don't find your joke amusing...


BTW for people who might actually be interested I found this site..

http://www.1keydata.com/sql/sqlselect.html

There are thick 1000+ page books on SQL (at least the Oracle SQL Reference Manual I have at my desk at work). Unless you give us something specific as a guide to what you are looking for, I doubt you are going to get much in the way of concise help.

Quote:

---

Originally Posted by hk_mp5kpdw

There are thick 1000+ page books on SQL (at least the Oracle SQL Reference Manual I have at my desk at work). Unless you give us something specific as a guide to what you are looking for, I doubt you are going to get much.

---

Thanks anyways I think this tutorial is exactly what I was looking for.

I'm sure you probably checked, but there are a lot on Google

Quote:

---

Originally Posted by sean_mackrory

GROUPY BY column1 [HAVING SUM(column2) operator1 value1];

INSERT INTO table1 (column1, column2) VALUES (value1, value2);

{LEFT} / {INNER} / {RIGHT} JOIN table1 ON column1 operator1 column2;

ORDER BY column1;

SELECT [DISTINCT] {column1, column2} / {column1,SUM(column2)} / {*} INTO table1 [IN database1] FROM table1 [WHERE column3 operator1 value1] [AND column4 operator2 value2 / OR column5 operator3 value3];

TRUNCATE TABLE table1;

UNION [ALL];

UPDATE table1 SET column1 = value1 WHERE column2 operator1 value2;

---

so true

what SQL are you using btw?