Results 1 to 6 of 6
  1. #1
    Join Date
    Mar 2003
    Posts
    130

    Question Unanswered: Online SQL reference

    Does anyone know of a quick online SQL reference or a dictionary of terms and sample strings?

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    A co-worker just introduced me to a good, lightweight SQL site that sounds like what you want. Check out http://sqlzoo.net/howto/source/s.pl.htm and please let me know what you think.

    -PatP

  3. #3
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    you didn't know about sqlzoo before?

    it's got a really nice interactive feature -- you can test your sql in multiple different database systems

    great for learning the different sql dialects

    there are links to all the different SQL Reference manuals on the home page -- http://sqlzoo.net/
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  4. #4
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    for additional SQL references, see my SQL Links page

    (note to self: man, i gotta check those links and update that page, it's been almost a year, and i have a whole bunch of new ones to add!!)
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  5. #5
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Quote Originally Posted by r937
    you didn't know about sqlzoo before?http://sqlzoo.net/
    I'm a hard core geek, and I lead a rather sheltered life... What can i say?

    -PatP

  6. #6
    Join Date
    Mar 2003
    Posts
    130
    Thanks, Pat. That's basically what I was looking for.

    I can't seem to find any info. on the query I'm trying...

    This is in Access and what I want to do is go through my tables and only keep five records.
    Code:
    DELETE * FROM Table1 WHERE ... NOT IN
    (SELECT TOP 5 * FROM Table1)
    I realize that's wrong and the only way I can get it to work is to specify key fields from the table:
    Code:
    DELETE * FROM Table1 WHERE key_field NOT IN
    (SELECT TOP 5 key_field FROM Table1
    ORDER BY key_field)
    The problem with that is the key_field is different for every table and I have about 500 tables I need to do this for. I need a more generic way to delete the records so I can reuse the query.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •