(. frame ) . 70- . . , , .
. . , "" : " , , , , 6-20 2 ". (, , , ), "", "", , , , .
. .
:
:
( 1- : 1- ), ( 2- : 2- ),
( N-ro : N- ).
-, , , -, .
, :
-, (, , );
- (, , );
- (, , );
- (, , ) .
.
. , .2 "" "" "", . , : " ?" : "", , "". , , "", .
. - ., .
.2.
SQL (Structured Query Language). SELECT. Between
SELECT
:
. |
From < >
[Where <. . >]
[Group by < >]
[Having <. >]
[Order by < >]
[] .
| - .
|
|
All ( ) . , . . . .
Distinct . .
* - . - . .
Where . . . . . .. . and, not, or :
1) >, <, >=,<=, =, <> 2) Between 3) in 4) Null
5) Like 6) All, Any, Some 7) Exists .
SQL . , . . :
1. (true)
2. (false)
3. (Null)
Between
Between A and B . . , , . . Not Between A and B , . . . , .
: ., 20 30
Select FIO
From P
Where Status Between 20 and 30 Where Status >= 20 and Status <= 30
- Between . ., . . . . , . . .
: .
Select *
From P and -
Where City Between and
: ., ,
Select *
From P
Where City Not Between and