This forum is a special repository for you to post your favorite SQL queries.

Unlike the question and answer format, this forum is for people who already know the answer to a recurring SQL problem, and want to have a safe place to store their information so that they can access it anytime, and from anywhere in the world.

Please give a brief description of the problem with the corresponding solution.

(Reminder: Please use the [ sql ] and [\ sql ] tags when writing SQL code)

Thanks,

Ben