SELECT SYNTAX

· SELECT identifies the columns to be displayed
· FROM identifies the table containing those columns.


Select all columns
SELECT * FROM departments;




Select specific columns
SELECT department_id, location_id
FROM departments;







0 comments:

Post a Comment