Basic SQL queries for Jet SQL, Paradox, dBase

new theme date Basic SQL DDL for MS-Access 2003-11-04 Basic SQL DDL for Paradox, dBase 2003-11-04 SQL queries syntax for desktop DBMS 2003-08-21 Limit number of records returned by SELECT 2004-02-01 Two ways to save query results into table 2010-09-29 Query with user defined parameters 2004-06-14 Simple uses of String functions CHR() and ASC() 2005-01-18 Simple uses of String functions MID() and UCase() 2008-11-27 Using wildcards in MS-Access LIKE function. 1 2009-07-16 Using wildcards in MS-Access LIKE function. 2 2011-02-28 Using list of values as condition in WHERE clause 2011-04-01 VBA FORMAT() time function 2007-08-28 Format mailing address using Mid and InStr functions 2004-06-14 Create empty copy of existing table 2004-06-14 To use DISTINCT everywhere is a bad habit 2005-12-05 Write condition in WHERE clause instead of HAVING 2005-12-05 SQL datatype formats for desktop DBMS 2003-11-04 ASCII Character Set 2003-10-10 Using Inner Join 2005-09-23 Using Outer Join 2005-09-23 Simple join between two tables 2009-04-12 Cartesian join between two tables 2007-11-16 Get random number using Rnd() function 2008-05-25 Deal with dates in Query condition 2009-12-03 Convert Character value to Integer 2010-02-21 Create Indexed Table 2011-04-10

sqlexamples.info