DML DQL
Excel
, :
a)
d)
e)
(2- )
: ( )
, ,
()
ACCESS EXCEL :
Office Microsoft Excel
: A1:D10 (), ( ) .
( 30 ), ( 30 1 ) ( 7 , , ; , ) ( ) ( ) ( ) 6
12, 3 : ( ) ( 1 ) ( ). 220 350 220 350. 2 1 220 2 350 220 350 ()
Excel =( ; ; ; )
50
SQL
ϳ - , where .
ϳ Select, Insert, Update, Delete.
Select 1., 2.
From 1, 2
Where 1.1 = 2.1;
1 2-
Select 1.*, 2.2
From 1, 2
Where 1.1 = 2.1;
1 1 = 2
.
|
|
, .
( , )
Select 1.*, 2.2
From 1, 2
Where 1.1 <> 2.1;
Select 1., 2.
From 1 as 1, 2 as 2
Where 1.1 = 2.1;
SQL
Select 1., 2.
From 1 as 1, 2 as 2;
= 2- 10 100
(SELF JOIN) , , SQL.
Select 1.1, 1.1
From 1 as 1, 1 as 2
Where 1.1 = 2.1;
SELECT 1.*, 2.
FROM 1 RIGHT JOIN 2 ON 1.1 = 2.1;
1 2- 2-
SELECT 1.*, 2.
FROM 1 LEFT JOIN 2 ON 1.1 = 2.1;
RIGHT
Select 1.1, 1.2
From 1 as 1, 2 as 2
Where 1.2 = (select 2.(n) from 2 where 2.(n) <> <>);
1 ( 9 AND OR) 1 = LIKE IN BETWEEN() <> (=,<>, >, <,=<, =>). <> , ,
Insert
insert into __
select 1.1, 1.2
from 1 as 1, 2 as 2
where Where 1.1 = 2.2 AND 2.2 = (select 2.(n) from 2 where 2.(n) <> <>);
UNION ' Select .
UNION ALL ' Select, .