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.
Printable View
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.
Thanks anyways I think this tutorial is exactly what I was looking for.Quote:
Originally Posted by hk_mp5kpdw
I'm sure you probably checked, but there are a lot on Google
so trueQuote:
Originally Posted by sean_mackrory
what SQL are you using btw?