, . , . , (), , . , SQL.
, SQL " ". , SQL. , SQL , - - . , SQL , .
?
, , , . , , , , , ( ), .
?
DML. , , , DML, , .
SQL . , , . SELECT ().
SELECT
, SELECT , . , , :
SELECT snum, sname, city, comm
FROM Salespeople;
3.1.
=============== SQL Execution Log ============
| SELECT snum, sname, city, comm |
| FROM Salespeople; |
| ==============================================|
| snum sname city comm |
| ------ ---------- ----------- ------- |
| 1001 Peel London 0.12 |
| 1002 Serres San Jose 0.13 |
| 1004 Motika London 0.11 |
| 1007 Rifkin Barcelona 0.15 |
| 1003 Axelrod New York 0.10 |
===============================================
3.1. SELECT
, . , , .
:
SELECT | , , . , . |
snum, sname | , . , , . , , , , , . |
FROM Salespeople | , SELECT, . . (Salespeople). |
; | SQL, , . (\) , . |
, . , . , , , . , . SQL , . , . , , .
|
|
( ENTER) . , , , :
SELECT snum, sname, city, comm FROM Salespeople;
SQL , , SQL ( ENTER) . SQL SQL.