Listing all the columns and rows in the employee table

You display information from a database using the SELECT statement. The following example shows the command to type in the Interactive SQL Classic (dbisqlc) command window. Once you have typed the command, click Execute to carry out the command. The example displays the first several columns and rows of the results of the query, which appear in the Interactive SQL Classic data window.

Enter:

SELECT *
FROM Employees

• In the examples, SQL keywords are shown in uppercase; however, SQL statements are case-insensitive.

• In many examples, each clause of a SQL statement is placed on a separate line for readability. You can enter SQL statements either all on one line, or you can break them over several lines.

The Interactive SQL Classic Data window displays a set of rows and columns containing information about the employees. Each row contains information about one employee, and each column contains a particular piece of information for all employees.