[ Pobierz całość w formacie PDF ]
FROM
[WHERE ]
[GROUP BY ]
[HAVING ]
[ORDER BY [ASC|DESC]]; --where ASC|DESC allows the ordering to be
done in ASCending or DESCending order
UPDATE
SET =
[WHERE ]; --if the Where clause is left out, all rows will be updated according to the Set
statement
Important Links
Computing & SQL/DB Links: Netscape -- Oracle -- Sybase -- Informix --Microsoft
SQL Reference Page -- Ask the SQL Pro -- SQL Pro's Relational DB Useful Sites
Programmer's Source -- DBMS Sites -- inquiry.com -- DB Ingredients -- SQL Trainer S/W
Web Authoring -- DBMS Lab/Links -- SQL FAQ -- Query List -- MySQL
Database Jump Site -- Programming Tutorials on the Web -- PostgreSQL -- Adobe Acrobat
DB Stuff -- DBMS/IS Pages -- Access on the Web -- Online Books -- A Good DB Course
Tutorial Page -- DBMS Magazine -- Database Mining -- miniSQL -- Adabas
Miscellaneous: CNN -- USA Today -- Pathfinder -- ZDNet -- CNet -- TechWeb -- LookSmart -- Amazon.com
Books
Search Engines: Yahoo -- Alta Vista -- Excite -- WebCrawler -- Lycos -- Infoseek -- search.com
These sites are encouraged, but not officially endorsed by the author.
Disclaimer
I hope you have learned something from this introductory look at a very important language that is becoming more
prevalent in the world of client-server computing. I wrote this web page in order to contribute something of value to
the web and the Internet community. In fact, I have been informed that this document is being used at several
colleges and companies for use in database classes, and as a resource for many others. In addition, I would like to
thank all of the people from across five continents who have contacted me regarding this web page.
In addition, I strongly urge you to visit some of the database links shown above, especially if you're interested in
advanced topics, such as the SQL-92 standard, different relational DBMS's, and advanced query processing.
Unfortunately, however, the number of database web sites remains small, and if you are unable to find the
information for which you are looking at the links displayed above, the information may not be available on the
web, and that you will have to potentially contact a database vendor for the information you seek. In fact, if you're
using a well-known, name-brand DBMS, the web site of your vendor is often the first and best place to look for
information...you'll just have to do some hunting for the documentation when you get there. Another good place is to
search for book publisher sites; you'll occasionally find some gems.
I also hope to continue to add more material to this tutorial, such as topics about database design and nonstandard
SQL extensions, even though I wish to stay away from material about individual Database Management Systems.
Good luck in your SQL and other computing adventures.
Jim Hoffman
Comments or suggestions? Mail me at jhoffman@one.net.
Or you may wish to look at Jim Hoffman's Web Pages for more information about myself, or my Algorithms
Tutorial.
Copyright 1996-1999, James Hoffman. This document can be used for free by any Internet user, but cannot be
included in another document, another web site or server, published in any other form, or mass produced in any way.
This page is best viewed with Netscape Navigator; it doesn't look quite right with Microsoft Internet Explorer.
Last updated: 1-12-1999; deleted links to download files.
http://w3.one.net/~jhoffman/sqltut.htm
[ Pobierz całość w formacie PDF ]