Simple selection (1)
•
SELECT * FROM sources
•
WHERE name = 'NGC7072';
•
•
result:
•
•
NAME
RA
DEC
BMAG
RMAG
•
---------- ---------- ---------- -------- --------
•
NGC7072
21.45694
-43.37306
14.31
13.33
•
De WHERE clause moet worden uitgelegd VOOR de DELETE/UPDATE en JOIN
Expressions are allowed in the selection clause and in the where clause