Advanced SQL queries

views theme date Delete records from one table using join with another table 2005-09-17 Concatenate data ignoring NULL values 2006-03-24 Using wildcards in MS-Access LIKE function 2008-05-31 User defined function in MS-Access SQL query 2006-03-24 MS-Access UDF function that replaces special characters 2008-10-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 Using Tally table to split sentence to words 2008-06-02 SQLServer Execution Plan elements. Part 1 2008-10-14 SQLServer Execution Plan elements. Part 2 2008-10-16 SQLServer Execution Plan elements. Part 3 2008-11-02 SQLServer Execution Plan elements. Part 4 2008-11-04

sqlexamples.info