.
. . . , ?
. :
- ;
- SELECT;
- , , .
: , . , .
, , . SELECT. SQL, .
.
WHERE . , AND.
: , "Menchu".
LAST_NAME ---------------- | DEPT_ID ---------------- | NAME ---------------- |
Menchu | Operations |
: , , .
LAST_NAME ----------------- | NAME --------------------- | COMMISSION_PCT ------------------------ |
Magee | North America | |
Giljum | Couth America | 12.5 |
Sedeghi | Africa / Middle East | |
Nguyen | Asia | |
Dumas | Europe | 17.5 |
... |
-.
- , . , (=).
: - . .
E.LAST_NAME ----------------- | E.TITLE -------------- | E.SALARY ------------ | S.GRADE ----------- |
SMITH | CLERK | 800.00 | |
ADAMS | CLERK | 1,100.00 | |
JAMES | CLERK | 950.00 | |
WARD | SALESMAN | 1,250.00 | |
MARTIN | SALESMAN | 1,250.00 | |
MILLER | CLERK | 1,300.00 | |
ALLEN | SALESMAN | 1,600.00 | |
TURNER | SALESMAN | 1,500.00 | |
JONES | MANAGER | 2,975.00 | |
BLAKE | MANAGER | 2,850.00 | |
CLARK | MANAGER | 2,450.00 | |
SCOTT | ANALYST | 3,000.00 | |
FORD | ANALYST | 3,000.00 | |
KING | PRESIDENT | 5,000.00 | |
14 rows selected |
, (, <= >=), BETWEEN.
|
|