http://www.netvouz.com/tag/reference?feed=rss&pg=134 Bookmarks tagged with "reference" on Netvouz http://www.free-cgi.com/freecgi/reference/sqlref.php SQL Quick Reference Guide Statements SELECT [ DISTINCT ] * | LIST OF COLUMNS, FUNCTIONS, CONSTANTS FROM LIST OF TABLES OR VIEWS [ WHERE CONDITION(S) ] [ ORDER BY ORDERING COLUMN(S) [ ASC | DESC ] ] [ GROUP BY GROUPING COLUMN(S) ] [ HAVING CONDITION(S) ] DELETE FROM TABLE NAME [ WHERE CONDITION(S) ] INSERT INTO TABLE NAME [ (COLUMN LIST) ] VALUES (VALUE LIST) UPDATE TABLE NAME SET COLUMN NAME = VALUE [ WHERE CONDITION ] Functions Function Purpose SUM Total of the values in a field. AVG Average of the values in a field. MIN Lowest value in a field. MAX Highest value in a field. COUNT Number of values in a field, not counting Null (blank) values. Predicates Predicate Description BETWEEN ... AND Compares a value to a range kapluni Thu, 04 Oct 2007 16:30:53 GMT http://www.brainyquote.com/quotes/authors/a/andy_rooney.html REFERENCE Datamaiden Wed, 03 Oct 2007 11:10:07 GMT http://www.quotationspage.com/quotes/Andy_Rooney/ REFERENCE Datamaiden Wed, 03 Oct 2007 11:09:21 GMT http://www.snopes.com/language/language.asp REFERENCE Datamaiden Wed, 03 Oct 2007 11:07:51 GMT http://java.sun.com/docs/books/tutorial/index.html darn1207 Tue, 02 Oct 2007 20:43:47 GMT http://www.econsultant.com/i-want-firefox-extension/ look at all these extensions! angesbiz Tue, 02 Oct 2007 12:02:41 GMT http://www.kidshealth.org/index.html tjhedgpeth Mon, 01 Oct 2007 18:42:53 GMT http://www.smashingmagazine.com/2007/10/01/introducing-yui-the-rising-giant/ mbeharry Mon, 01 Oct 2007 14:04:44 GMT http://www.thespanner.co.uk/2007/09/19/javascript-for-hackers/ mbeharry Mon, 01 Oct 2007 14:02:04 GMT http://www.file-extensions.org/ hno Mon, 01 Oct 2007 12:14:04 GMT