Question

write a query to select certain column from a table​

Answer 1

Answer:

To select all columns of the EMPLOYEES Table:

Click the icon SQL Worksheet. The SQL Worksheet pane appears.

In the field under "Enter SQL Statement:", enter this query: SELECT * FROM EMPLOYEES;

Click the Execute Statement. The query runs.

Click the tab Results. The Results pane appears, showing the result of the query.

hope it helped u ♥