Book of tasks on programming. Old version

 

 by Aliaksandr N. Prykhodzka

 

form, var, for, query, variable, servlet, on-line, visual basic, Excel, monitor, CD-ROM, implementation, example, лекция, counter, null, трассировка, view
 

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

SQL. S.2. Nest of tasks. Operator Inner Join

 

 

Calculator

/ - division

\ - rest

S - sum of numbers from and to

P - multiply numbers from and to

S.2.1     Answer

Determine quantity of records fetched by this Select-operator:


Select AA, BB, CC
from Tabl1 Inner Join Tabl2
where Tabl1.AA=Tabl2.CC

 

 

Calculator

/ - division

\ - rest

S - sum of numbers from and to

P - multiply numbers from and to

S.2.2     Answer

Determine quantity of records fetched by this Select-operator:


Select AA, BB, CC from Tabl1, Tabl2

 

 

Calculator

/ - division

\ - rest

S - sum of numbers from and to

P - multiply numbers from and to

S.2.3     Answer

Determine quantity of records fetched by this Select-operator:


Select AA, BB, CC from Tabl1 Inner Join Tabl2

 

©   Aliaksandr Prykhodzka    1993 - 2007