EasyBasic SELECT
Select all departments and their locations
The query
SQL
SELECT dept_name, location, budget
FROM departments
ORDER BY dept_name ASC;Note
“ASC is the default sort order, so it can be omitted, but explicit is better for readability.
SELECT dept_name, location, budget
FROM departments
ORDER BY dept_name ASC;Note
“ASC is the default sort order, so it can be omitted, but explicit is better for readability.