home
Advanced SQL queries



themedate
Delete records from one table using join with another table 2009-10-27
Concatenate data ignoring NULL values 2006-03-24
User defined function in MS-Access SQL query 2006-03-24
MS-Access UDF function that replaces special characters 2008-10-08
UDF Min/Max value function in MS-Access SQL 2011-04-08
Build Sales reports using MS-Access queries 2006-05-09
Calculate correct age in MS-Access query 2008-04-21
Avoid to use subquery returning multiple rows 2006-11-21
Don't be afraid to use subqueries 2006-11-21
Find records with the same attributes 2007-01-13
Using Indexes to improve queries performance 2006-08-07
"ALL" option in UNION clause 2005-04-19
Self Join between two instances of the same table 2005-09-23
Calculate distance between two points 2006-10-14
Milliseconds part of MS-Access date 2007-12-14
Graph example: Road network. Part 1 2008-04-10
Graph example: Road network. Part 2 2008-04-14
Graph example: Road network. Part 3 2008-04-17
Find two latest invoices of the sales person 2008-05-26
Create tally table of 100 sequential numbers in MS-Access 2009-01-12
Create tally table of 10000 sequential numbers in MS-Access 2009-05-23
Using Tally table to split sentence to words 2008-06-02
Identify and Remove Duplicate records 2011-03-17
Find Dubious Translations in Address list 2011-04-02


sqlexamples.info