/sqlex

My solutions for the exercises from www.sql-ex.com

Primary LanguageSQLPL

sqlex

This repo contains solutions to the exercises, presented on the website http://www.sql-ex.com.
These are SQL statements for retrieval or modification of specific data.

Topics covered by the exercises:

  • simple SELECT, INSERT, UPDATE, DELETE statements
  • INNER and OUTER JOIN operations
  • UNION, INTERSECT and EXCEPT operations
  • predicates: trinary logic; SOME, ANY, ALL, EXISTS, LIKE, IN, NOT IN
  • subqueries (uncorrelated and correlated), WITH statement
  • GROUP BY and HAVING clauses, aggregate functions
  • CASE statement