Book of tasks on programming. Old version

 

 by Aliaksandr N. Prykhodzka

 

символьный, code, pascal, bit, nil, Internet, система счисления, лабораторный, external, open, двоичный, const, logical, address, html, самообразование
 

for valuable work you must have JavaScript (allow active content)

SQL. S.3. Nest of tasks. Operator Group by

 

 

Calculator

/ - division

\ - rest

S - sum of numbers from and to

P - multiply numbers from and to

S.3.1     Answer

Determine quantity of records fetched by this Select-operator:


Select Sum(EE) from Tabl3 Group by DD

 

 

Calculator

/ - division

\ - rest

S - sum of numbers from and to

P - multiply numbers from and to

S.3.2     Answer

Determine quantity of records fetched by this Select-operator:


Select Count(DD) from Tabl3 group by EE

 

©   Aliaksandr Prykhodzka    1993 - 2007