Say Yes to New Adventures

"Lorem Ipsum has been the industry's standard dummy text ever since the 1500s." — James Chapman

SQL SELECT Statement

The SELECT statement is used to select data from a database.

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

SELECT Syntax

SELECT column1, column2, ...

FROM tablename;

Here, column1, column2, ... are the field names of the table you want to select data from. If you want to select all the fields available in the table, use the following syntax:

SELECT * FROM tablename;

SELECT Column Example

The following SQL statement selects the "first_name" and "last_name" columns from the "patients" table:

SELECT first_name, last_name FROM patients;

Try Now

SELECT * Example

The following SQL statement selects all the columns from the "patients" table:

SELECT * FROM patients;

Try Now

Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry's standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book.

Shiva Vashishtha
A California-based travel writer, lover of food, oceans, and nature.

SQL Interview Questions: A Comprehensive Guide

Say Yes to New Adventures

You may also be interested in