Book of tasks on programming. Old version

 

 by Aliaksandr N. Prykhodzka

 

or, среда разработки, навучальны зборнiк па праграмаванню, asm, tree, algol, list, протокол, type, reusing, destructor, образование, object, database
 

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

SQL. S.1. Nest of tasks. Operator Select

 

 

Calculator

/ - division

\ - rest

S - sum of numbers from and to

P - multiply numbers from and to

S.1.1     Answer

Determine quantity of records fetched by this Select-operator:


Select * from Tabl1

 

 

Calculator

/ - division

\ - rest

S - sum of numbers from and to

P - multiply numbers from and to

S.1.2     Answer

Determine quantity of records fetched by this Select-operator:


Select count(*) from Tabl1

 

 

Calculator

/ - division

\ - rest

S - sum of numbers from and to

P - multiply numbers from and to

S.1.3     Answer

Determine quantity of records fetched by this Select-operator:


Select AA, BB from Tabl1 where BB=AA+1

 

 

Calculator

/ - division

\ - rest

S - sum of numbers from and to

P - multiply numbers from and to

S.1.4     Answer

Determine quantity of records fetched by this Select-operator:


Select AA from Tabl1 where AA<10

 

 

Calculator

/ - division

\ - rest

S - sum of numbers from and to

P - multiply numbers from and to

S.1.5     Answer

Determine quantity of records fetched by this Select-operator:


Select AA from Tabl1 where AA*BB<9

 

 

Calculator

/ - division

\ - rest

S - sum of numbers from and to

P - multiply numbers from and to

S.1.6     Answer

Determine quantity of records fetched by this Select-operator:


Select AA, BB from Tabl1 where AA=BB

 

©   Aliaksandr Prykhodzka    1993 - 2007