PDA

View Full Version : Crash SQL Course



incognito
01-03-2005, 05:46 PM
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.

sean
01-03-2005, 07:31 PM
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;

incognito
01-03-2005, 08:26 PM
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

hk_mp5kpdw
01-03-2005, 08:40 PM
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.

incognito
01-03-2005, 08:42 PM
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.

ober
01-04-2005, 06:55 AM
I'm sure you probably checked, but there are a lot on Google (http://www.google.com/search?q=advanced+sql+tutorial&sourceid=opera&num=0&ie=utf-8&oe=utf-8)

Brian
01-04-2005, 07:08 AM
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

whackaxe
01-04-2005, 09:37 AM
what SQL are you using btw?