A Tour of SQL
Lesson 2: Select *
The most basic SQL statement is Select * from [table_name];

Select * from [table_name]will output all datasets from a table in no particular order.

We have prepared the following tables for you for this lesson:

tbl_customers
tbl_invoices
tbl_addresses

Try changing and executing the SQL statement in the right window and then changing it to output all datasets from the other tables as well.

If you get stuck, you can click on the button Show solution and the code in the right window will update. Or click on Hint for a hint.

   

 

select * from tbl_customers;






 
 
             



Share