Ҳ ̲
1.
1.1.
: , , .
1) . , , . , .
2) . , 10 5 . .
3) . :
- ;
- , . , .
4) . :
- Microsoft Access;
- , ;
- ﳿ .
- , ;
- 䳿 , SQL.
SQL
Access , ( QBE). SQL :
- '. () () ;
- ;
- . ' , , Microsoft Access.
SQL , Access. SQL:
select - SQL, . select , . * select, ;
distinct , SQL;
distinctrow ;
from , () ;
join - ' , ;
where , ;
|
|
union - ;
order by ;
group by , . group by select, avg, count, sum .
, and, or not, : between, in, like.
. :
1) , , 泔, : , , , , ֳ, ʳ .
2) 泔 , : ֳ.
3) . . , ֳ . [ ].
4) , , , - , . Not <>.
5) 泔 , ֳ ʳ Like. , .
6) ֳ , .
7) 泔 , , , . D(), nth(), Year(). , , , Day( ), , >10.
8) 泔, SQL-, .
9) SQL- ' _21 _22, . .
. _21 _22 , , Գ, .
, 䳿:
1) .
2) .
3) , ' .
4) ', , . .
5) .
6) , , , - . .
7) .
3.
1. ?
|
|
2. ?
3. ?
4. ?
5. : between, in, like?
6. Access: Day, Month, Year, Weekday.
7. ?
8. Access ?
9. ? ?