MySQL SELECT Queries - Understanding the SELECT Statement

Retrieve Specific Columns

Write a SELECT query to retrieve only the first_name and email columns from the customers table.

Expected output: A list of first names and emails from the customers table.

Hint: Use SELECT with column names separated by commas.

Filter Data with WHERE

Write a SELECT query to find all products with a price greater than 100.

Expected output: All product rows where price is above 100.

Hint: Use WHERE clause with a condition on the price column.

Sort Results

Write a SELECT query to get all employees ordered by their hire_date ascending.

Expected output: Employees listed from earliest to latest hire date.

Hint: Use ORDER BY with the hire_date column.

The SELECT statement retrieves data from one or more tables in a MySQL database based on specified columns and optional filtering or sorting.

Use SELECT * FROM table_name; to retrieve all columns from the specified table.

By using the WHERE clause with conditions to specify which rows to return.