Common mistakes in solving SELECT statement exercises

Then followed a number of exemplary dialogues between the teacher and the student, altogether incomprehensible for the rational ear and absurd in terms of any dualistic or binary logics; teachers mostly answered their students questions by beating them on the head with a stick, pouring out a jug of cold water over their head, toeing them out of the room or at best repeating the same question staring into their face.

Hopscotch, Julio Cortazar

In this part of the book, we analyze erroneous solutions to exercises of the learning and first rating stages of the SQL Exercises website. Usually, we dont provide correct solutions except for the simplest exercises, where we do so to facilitate the initial phase of learning for beginners. Nevertheless, many of the solutions presented here are almost correct, so that fixing them wont pose any difficulties once the cause of the problem is understood. Some clues are provided in a separate chapter named Tips and solutions, which contains additional comments and consideration of some alternative solution approaches.

Bookmark and Share


aggregate functions Airport ALL AND AS keyword ASCII AVG Battles Bezhaev Bismarck C.J.Date calculated columns Cartesian product CASE cast CHAR CHARINDEX Chebykin check constraint classes COALESCE common table expressions comparison predicates Computer firm CONSTRAINT CONVERT correlated subqueries COUNT CROSS APPLY CTE data type conversion data types database schema DATEADD DATEDIFF DATENAME DATEPART DATETIME date_time functions DDL DEFAULT DEFAULT VALUES DELETE DISTINCT DML duplicates edge equi-join EXCEPT exercise (-2) More tags
The book was updated
several days ago
©SQL-EX,2008 [Evolution] [Feedback] [About] [Links] [Team]
All right reserved.