A Tour of SQL
Lesson 3: Selecting fields
Instead of Select * , you can also specifiy the field names that you want to output. This enables you as well to make sure that the field names appear in partical order:

You separate different field names with a "," (but do not add a "," after the last field name.

The table tbl_customers contains the following field names:
customer_id
first_name
last_name

Try changing and executing the SQL statement in the right window and then play around a bit to output other field names or to output them in a different order.

   
 

select first_name, last_name from tbl_customers;






 
 
             



Share