Comment by JosephHatfield

Check out Joe Celko's book, SQL for Smarties; There are some mind-blowing SQL techniques in that book.