This query will retrieve the “first_name” column as “First Name” and the “last_name” column as “Last Name” in the result set.
Filtering Rows with WHERE Clause
The WHERE clause is used to filter rows based on specific conditions. Here’s an example:
SELECT * FROM employees WHERE department = 'IT';
This query will retrieve all columns from the “employees” table where the “department” column is equal to ‘IT’.
