Thread: Crash SQL Course

  1. #1
    left crog... back when? incognito's Avatar
    Join Date
    Oct 2001
    Posts
    1,427

    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.
    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.

  2. #2
    Registered User
    Join Date
    Sep 2001
    Posts
    4,912
    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;

  3. #3
    left crog... back when? incognito's Avatar
    Join Date
    Oct 2001
    Posts
    1,427
    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.

  4. #4
    Registered User hk_mp5kpdw's Avatar
    Join Date
    Jan 2002
    Location
    Northern Virginia/Washington DC Metropolitan Area
    Posts
    3,817
    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

  5. #5
    left crog... back when? incognito's Avatar
    Join Date
    Oct 2001
    Posts
    1,427
    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.
    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.

  6. #6
    5|-|1+|-|34|) ober's Avatar
    Join Date
    Aug 2001
    Posts
    4,429
    I'm sure you probably checked, but there are a lot on Google

  7. #7
    Registered User
    Join Date
    Jan 2002
    Location
    Vancouver
    Posts
    2,212
    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

  8. #8
    Registered User whackaxe's Avatar
    Join Date
    Mar 2004
    Posts
    332
    what SQL are you using btw?
    I loathe pointers

Popular pages Recent additions subscribe to a feed

Similar Threads

  1. Speed/size advantage to SQL?
    By MK27 in forum Tech Board
    Replies: 15
    Last Post: 06-26-2009, 11:28 AM
  2. OOP Question DB Access Wrapper Classes
    By digioz in forum C# Programming
    Replies: 2
    Last Post: 09-07-2008, 04:30 PM
  3. Embedded SQL
    By sarac in forum C Programming
    Replies: 1
    Last Post: 05-04-2006, 09:09 AM
  4. Replies: 1
    Last Post: 03-21-2006, 07:52 AM
  5. Problem with embedded SQL in C/C++ (ECPG)
    By NeuralClone in forum C Programming
    Replies: 4
    Last Post: 10-21-2005, 05:16 PM