SELECT Statement

The SELECT statement can print the information on the screen in a new pane.

Clauses that make up the SELECT statement:

  • SELECT
  • FROM
  • HWERE
  • GROUP BY
  • HAVING
  • ORDER BY

We can select the entire table or we can specify the columns that we want to select.

for example, if we want to get all the columns, we could use the SELECT * statement

SELECT *
FROM table_name

or to get specific column names
SELECT column_1, column_2, column_3, etc
FROM table_name

Leave a Comment

Your email address will not be published. Required fields are marked *

Scroll to Top