loading..
   English
21:58

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

Content:

Tags
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 date/time functions DATEADD DATEDIFF DATENAME DATEPART DATETIME DDL DEFAULT DEFAULT VALUES DELETE DISTINCT DML duplicates equi-join EXCEPT exercise (-2) exercise 19 More tags
The book was updated
several days ago
©SQL-EX,2008 [Evolution] [Feedback] [About] [Links] [Team]
All right reserved.
Rambler's Top100