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:

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;