, SELECT DISTINCT ().
, :
SELECT DISTINCT E_BORN FROM Employees
.
SQL - .
(join) .
, , , .
, , . , , , WHERE.
, , FROM. , , :
Employees.E_ID
Employees.E_NAME
, , . SQL "", .
SELECT , , , .
, , . where, (, ).
, WHERE .
( ) , , , , , . SELECT , . , () .
SQL :
COUNT - , NULL-;
SUM - , -;
|
|
AVG - , -;
- , -;
MIN - , -.
( COUNT (*)) DISTINCT .
:
SELECT SUM(O_ID) FROM Orders
.
- , ALTER TABLE. , : . . , .
:
ALTER TABLE < >
ADD < > < > <> NULL
NULL . .
, :
ALTER TABLE < >
DROP < > < >
, . , , , ( ).
.
( ), , (. 2).