1. Type SELECT , followed by the names of the columns in the order that you want them to appear on the report. …
2. If you know the table from which you want to select data, but do not know all the column names, you can use the Draw function key on the SQL Query panel to display the column names

The SQL SELECT Statement

1. SELECT column1, column2, FROM table_name;
2. SELECT * FROM table_name;
3. ExampleGet your own SQL Server. SELECT CustomerName, City FROM Customers; Try it Yourself »
4. Example. SELECT * FROM Customers;

The SQL SELECT Statement

1. SELECT column1, column2, … FROM table_name;
2. SELECT * FROM table_name;