User contributions
- 20:40, 31 March 2013 (diff | hist) . . (+9) . . Self join (As stated, Question 7 result should only give one line for each unique pair of company, num; thus added DISTINCT.) (top)
- 18:31, 23 March 2013 (diff | hist) . . (-5) . . SELECT within SELECT Tutorial (MAX on gdp is unnecessary when using ALL in this case. Both work, and MAX is cleaner, but this example is supposed to be all about the ALL.)
- 23:05, 19 March 2013 (diff | hist) . . (-1) . . SELECT within SELECT Tutorial (Changed question text ( removed a '0' ) quantity to match quantity in answer SQL. I am starting to suspect someone is subtly corrupting this page.)
- 17:12, 19 March 2013 (diff | hist) . . (-51) . . SELECT within SELECT Tutorial (Question 6 asks for area, but the answer SQL was the same as the example, and gave country with greatest population. I tweaked the question text to ask for continent, name, and area. I changed the answer SQL to check for greatest area.)