, (. ), : 3, _# =3, 5, _=5, :
SELECT *
FROM [ ]
WHERE (([ ].[_#])=3)) OR (([ ]._)=5));
:
³ ( SQL). , , ( ), .
* SELECT , ( ) , FROM, ( ), , WHERE.
, WHERE, (=, <,= >, <, >=, <>), AND, NOT, OR, , , .
WHERE , , :
SELECT *
FROM [ ]
WHERE ((([ ].[_#])=3));
, Microsoft Access SQL.
SQL SQL ( , SQL). , SQL, .
b)
, , , :
SELECT [ ].[_#], [ ]._, [ ]., [ ].[ֳ ]
FROM [ ]
ORDER BY [ ].;
:
ORDER BY , ( ). DESC , ASC- . DESC/ ASC , , ORDER BY.
. SQL SELECT *, . .
c)
,
SELECT [ ]._, [ ].[_#], [ ].[__#]
FROM [ ]
|
|
|
WHERE ((([ ]._)=[ ]))
ORDER BY [ ].[_#];
5.1.2. Գ
a) , ( _ _# =1)
SELECT [ ].[_], [ ].[_#]
FROM [ ]
WHERE ([ ].[__#] =1)
ORDER BY [ ]._;
:
| _ | # | |
b) .
, SQL- DISTINCT.
SQL- ( SQL)
SELECT DISTINCT [ ]._, [ ].[_#]
FROM [ ]
WHERE ([ ].[__#]=1)
ORDER BY [ ].[_];
, .
| _ | # |
:
, - , SELECT.
ORDER BY < > SELECT.
ORDER BY , SELECT.
, ASC - ( )
WHERE, FROM
, , - () , AND, OR, NOT.
SQL- IS .
SQL :
1. TRUE- , - 1;
2. FALSE- - , 0;
3. UNNOWN - - 0,5.
:
TRUE AND UNNOWN = UNNOWN,
FALSE OR UNNOWN = UNNOWN,
NOT UNNOWN= UNNOWN.
( SQL CHARACTERE) . .
5.1.3.
, , 60 180 . .
SELECT [ ].[_#], [ ].[_], [ ].[], [ ].[ֳ ]
|
|
|
FROM [ ]
WHERE (([ ].[ֳ ]) Between 60 And 180)
ORDER BY [ ].[ֳ ] DESC;
:
Between , .
, , .
5.1.4. ( Like) IN
:
a) , , .
SELECT [ ].[_], [ ].[], [ ].[ֳ ]
FROM [ ]
WHERE ((([ ]._) Like "*"));
:
Like , Like SQL.
Like
Like ""
SQL, WHERE,
, . . :
- * - - - , : *, *, **, ;
- ?- ,, ,: ??,?, ???, a?*, .
: SQL * _, ? %.
b) :
SELECT [ ].[__#],
[ ]._
FROM [ ]
WHERE (([ ]._) Not Like "*");
$ .
:
, , , ( NULL), TRUE .
0, TRUE.
c) IN
IN , .
IN:
[Not] In(_1, _2,...)
In:
: , , ;
_1, _2, : , - .
, In True; - False. Not ( ).
: , 30, 34 50 .
SELECT [ ]._, [ ].[ֳ ]
FROM [ ]
WHERE ((([ ].[ֳ ]) In (30,50,34)));
5.1.5.
. , , . .
SELECT [ ]._, [ ].[_#], [ ].[__#]
FROM [ ]
WHERE ((([ ]._) Is Null)) OR ((([ ]._) Is Null)) OR ((([ ].[_#]) Is Null)) OR ((([ ].[__#]) Is Null));
:
( ), .
|
|
|
Is [Not] Null / .
Is [Not] Null (, ).
5.1.6.
:
OUNT(*), OUNT(<>), AVG, MIN, MAX,
AVG, MIN, MAX .
OUNT(*) , .
OUNT(<>)- .
( ) , , . SELECT. :
a) , , , , .
SELECT Max([ ].[ֳ ]) AS , Avg([ ].[ֳ ]) AS _
FROM [ ]
WHERE (([ ].) Not Like "*");
:
| _ | |
| 53,8 |
:
, , , SELECT.
.
, AS, , ( _).
, _, _.
b) ().
GROUP BY. : ϳ , .
SELECT [ ].[_#], Count(*) AS [ʳ]
FROM [ ]
GROUP BY [ ].[_#]
ORDER BY Count(*) DESC;
:
, SELECT.
GROUP BY .
GROUP BY, , , GROUP BY, , .
| # | ʳ |
Count(*), GROUP BY . . .
SELECT. AS.
: , , , ; SQL.
c)
|
|
|
: , .
SELECT [ ]._, Count([ ].[_#]) AS [ʳ #]
FROM [ ]
GROUP BY [ ]._
HAVING (([ ]._)=[ ]);
:
ϳ , ( ), , Count, , .
_# ( ) , , .
, , _#, , , .
HAVING , HAVING ,
HAVING (([ ]._)=[ ]);
, , .
.
HAVING
HAVING , , , WHERE, HAVING.
, , , .
SELECT (. 3, . 18) FROM , , , . : . , , .
5.2.1. ,
, FROM ᒺ, .
ᒺ .
. ( , ) :
SELECT *
FROM ,
WHERE a# =b#;
ᒺ , # b#. , .
:
1. : ϳ , , , , , 1, 2, 3.
, .
SQL- :
SELECT [ ].[_], [ ]._, [ ].[_#], [ ]., [ ].[__#], [].
FROM [] INNER JOIN ([ ] INNER JOIN [ ] ON [ ].[_#] = [ ].[_#]) ON .[ ] = [ ].
WHERE ((([ ]._)<4) AND (([ ].[__#])<4) AND ((.)<"*"));
:
| _ | _ | # | __ | ||
| 05.08.2010 | . . | ||||
| 01.09.2010 | . . | ||||
| 01.09.2010 | . . | ||||
| 05.08.2010 | . . | ||||
| 01.05.2010 | . . | ||||
| 01.05.2010 | . . |
:
|
|
|
[ ], [ ], [ ].
³ .
, , :
[ ].[_#]=[ ].[_#].
, , , , , , . , , .
Ⳕ :
((([ ]._)<=3) AND (([ ].)<"*") AND (([ ].[__#])<4));
, .
ᒺ AND , WHERE.
( ) , , 璺 , , .
SELECT.
