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.
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.
There are some real morons in this world please do not become one of them, do not become a victim of moronitis. PROGRAMMING IS THE FUTURE...THE FUTURE IS NOW!!!!!!!!!
"...The only real game I thank in the world is baseball..." --Babe Ruth
"Life is beautiful"-Don Corleone right before he died.
"The expert on anything was once a beginner" -Baseball poster I own.
Left cprog on 1-3-2005. Don't know when I am coming back. Thanks to those who helped me over the years.
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 some real morons in this world please do not become one of them, do not become a victim of moronitis. PROGRAMMING IS THE FUTURE...THE FUTURE IS NOW!!!!!!!!!
"...The only real game I thank in the world is baseball..." --Babe Ruth
"Life is beautiful"-Don Corleone right before he died.
"The expert on anything was once a beginner" -Baseball poster I own.
Left cprog on 1-3-2005. Don't know when I am coming back. Thanks to those who helped me over the years.
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.
Last edited by hk_mp5kpdw; 01-03-2005 at 08:43 PM.
"Owners of dogs will have noticed that, if you provide them with food and water and shelter and affection, they will think you are god. Whereas owners of cats are compelled to realize that, if you provide them with food and water and shelter and affection, they draw the conclusion that they are gods."
-Christopher Hitchens
Thanks anyways I think this tutorial is exactly what I was looking for.Originally Posted by hk_mp5kpdw
There are some real morons in this world please do not become one of them, do not become a victim of moronitis. PROGRAMMING IS THE FUTURE...THE FUTURE IS NOW!!!!!!!!!
"...The only real game I thank in the world is baseball..." --Babe Ruth
"Life is beautiful"-Don Corleone right before he died.
"The expert on anything was once a beginner" -Baseball poster I own.
Left cprog on 1-3-2005. Don't know when I am coming back. Thanks to those who helped me over the years.
I'm sure you probably checked, but there are a lot on Google
so trueOriginally Posted by sean_mackrory