http://netvouz.com/tag/sql?feed=rss&pg=4 Bookmarks tagged with "sql" on Netvouz http://www.w3schools.com/sql/ Well organized easy to understand SQL tutorial with lots of examples. Including PHP, ASP, ADO, Oracle, Access, SQL Server. Related: HTML, JavaScript, XML, XQuery Software BearCan Wed, 05 Dec 2007 13:30:42 GMT http://www.firebirdsql.org/ cattus Wed, 05 Dec 2007 09:02:12 GMT http://josql.sourceforge.net/ SQL for Java Objects kapluni Tue, 04 Dec 2007 18:25:46 GMT http://www.programmertutorials.com/ Articles, tutorials and resources for programmers! jdrsantos Fri, 09 Nov 2007 16:04:43 GMT http://www.codinghorror.com/blog/archives/000989.html Interesting take on middle layer generation. GollyJer Thu, 08 Nov 2007 00:00:39 GMT http://www.microsoft.com/downloads/details.aspx?FamilyID=1d3a4a0d-7e0c-4730-8204-e419218c1efc&DisplayLang=en SQL Server 2005 Performance Dashboard Reports kapluni Tue, 23 Oct 2007 13:56:40 GMT http://www.pantz.org/database/mysql/mysqlcommands.shtml Code > SQL search4ward Thu, 18 Oct 2007 21:22:18 GMT http://www.codinghorror.com/blog/archives/000976.html A Visual Explanation of SQL Joins GollyJer Fri, 12 Oct 2007 20:01:38 GMT http://troels.arvin.dk/db/rdbms/ Programmierung > SQL jendrek Sat, 06 Oct 2007 20:56:10 GMT 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