Using MySQL SELECT Statement to Query Data: Examples

Back Home

SELECT lastName 
FROM employees;

SELECT 
    lastname, 
   firstname, 
   jobtitle 
FROM 
   employees;

SELECT * FROM employees;

SELECT * FROM customers;

SELECT * FROM employees;

SELECT * FROM offices;

SELECT * FROM orderdetails;

SELECT * FROM orders;

SELECT * FROM payments;

SELECT * FROM productlines;

SELECT * FROM products;

Execute

Clear Beautify Minify