Books and articles about SQL Rambler's Top100 Сменить язык на: Русский 27 May 2024 14:56:56
Skip Navigation Links  


Typical errors at solution of exercises (database "Recycling firm")

AuthorS. Moiseenko

Exercise 47

For each working day (i.e. day when waste was collected), find the #1 in payouts in each pair of inlets having the same numbers in the 2 tables - outcome and outcome_o.
Result set: Inlet #, date, text:
- "once a day", if daily reporting inlet is in the lead;
- "more than once a day", if several times a day reporting inlet is in the lead;
- "both", for draw cases.

Usage of any materials of this site is possible
only under condition of mandatory allocation of the direct link to a site
on each page where used materials are placed.

 Main   Articles    Books 
Рейтинг Rambler's Top100 Alt Упражнения по SQL: обучение, тестирование, сертификация по языку SQL Copyright c 2002-2006. All rights reserved.