Description

The SQL keyword SELECT is used to select data from a database, from one or more tables.

  • The data returned is stored in a result table, called the result set.

SELECT Specific Columns

The below SQL fetched data from specific columns of a table.

SELECT customer_id, customer_name, address, city
FROM customers;

SELECT All Columns

The below SQL fetches data from all the columns of a table.

SELECT * 
FROM customers;

Related Links