SQL

• EXISTS operator returns TRUE if a subquery contains any rows
• Update Join syntax in TSQL
• Creating cross tab queries and pivot tables in SQL
• T-SQL code to find out the nth highest number in a column