.


:




:

































 

 

 

 


UPDATE




UPDATE . , , WHERE . , SQL , : , , . UPDATE <> SET {<> = <>} [WHERE < >] UPDATE <> SET {<> = (SELECT <> FROM <> WHERE < >)} [WHERE < >] INSERT . . , . SQL - SELECT ( ). , SELECT , . INSERT INTO <> [(< >)] VALUES (< >) INSERT INTO <> [(< >)] (SELECT < > FROM <> WHERE < >) DELETE , . . , , WHERE . SQL DELETE . ( WHERE) . DELETE FROM <> [WHERE < >] DELETE < > FROM < > [WHERE < >]

29. , FULL JOIN CROSS JOIN,
UNION.

FULL JOIN - , .

SQL FULL JOIN

SELECT column_name(s)

FROM table_name1

FULL JOIN table_name2

ON table_name1.column_name=table_name2.column_name

 

"Persons":

"Orders":

.

:

SELECT Persons.LastName, Persons.FirstName, Orders.OrderNo FROM Persons FULL JOIN Orders ON Persons.P_Id=Orders.P_Id ORDER BY Persons.LastName FULL JOIN - , .

SQL FULL JOIN

SELECT column_name(s)

FROM table_name1

FULL JOIN table_name2

ON table_name1.column_name=table_name2.column_name

"Persons":

"Orders":

.

SELECT Persons.LastName, Persons.FirstName, Orders.OrderNo

FROM Persons

FULL JOIN Orders

ON Persons.P_Id=Orders.P_Id

ORDER BY Persons.LastName

UNION - SELECT.

, SELECT UNION . .

SQL UNION

SELECT column_name(s) FROM table_name1

UNION

SELECT column_name(s) FROM table_name2

: UNION . , UNION ALL.

SQL UNION ALL

SELECT column_name(s) FROM table_name1

UNION ALL

SELECT column_name(s) FROM table_name2

, "" Norway USA.

:

SELECT E_Name FROM Employees_Norway UNIONSELECT E_Name FROM Employees_USA

30. . IN NOT IN IN NOT IN SQL . WHERE. , 18. IN:

SELECT S_POSITION, COUNT(S_POSITION) AS [ S_POSITION]

FROM D_STAFF

WHERE S_POSITION IN (22,24)

GROUP BY S_POSITION

HAVING COUNT(S_POSITION)>1

NOT IN>:

SELECT S_POSITION, COUNT(S_POSITION) AS [ S_POSITION]

FROM D_STAFF

WHERE S_POSITION NOT IN (23)

GROUP BY S_POSITION

HAVING COUNT(S_POSITION)>1

, 18, , . , , SELECT, . , - :

SELECT PROFILE_ID, COUNT(PROFILE_ID) AS [ S_POSITION]

FROM D_STAFF_PROFILE

WHERE PROFILE_ID NOT IN (SELECT XD_IID FROM D_PROFILE WHERE P_NAME LIKE'%')

GROUP BY PROFILE_ID , NOT IN, XD_IID, SELECT. D_STAFF_PROFILE. Ԓ. , 21, 22, 23, , .





:


: 2017-01-28; !; : 701 |


:

:

80% - .
==> ...

801 - | 742 -


© 2015-2024 lektsii.org - -

: 0.012 .