SQL:

• How to check SQL query construction with the Mimer Validator

  Answer - Read about the Mimer Validator, a tool used to verify your SQL code, in this tip from SQL expert Rudy Limeback. 09 April 2009

• How to use an SQL CASE expression

  Answer - Read an example of an SQL case expression from our SQL expert Rudy Limeback. 09 April 2009

• Using the SQL GROUP BY clause for counting combinations

  Answer - Read SQL expert Rudy Limeback's advice for counting combinations in a table with SQL's GROUP BY clause 09 April 2009

• How to sort an SQL UNION query with special ORDER BY sequence

  Answer - SQL expert Rudy Limeback explains how to sort an SQL UNION query using a special ORDERY BY sequence. 19 February 2009

• How to use string functions to make an SQL join

  Answer - SQL expert Rudy Limeback explains how to use string functions to make an SQL join using only a portion of a column value. 19 February 2009

• An SQL solution for a customer order homework problem

  Answer - How do you select a max value in an SQL customer order table? Learn the answer here. 13 January 2009

• How to use SQL's POSITION function with substrings

  Answer - Expert Rudy Limeback explains with an example how to use the SQL POSITION function with substrings. 13 January 2009

• Using SQL date functions to get totals for last three days

  Answer - How can you use SQL date functions to get totals for the last three days in a table? Find out in this expert tip. 13 January 2009

• Using CASE in the SQL ORDER BY clause

  Answer - Read about why one Oracle user is getting an error when trying to use CASE in the SQL ORDER BY clause. 12 January 2009

• What's the difference between an SQL inner join and equijoin?

  Answer - 05 December 2008