SQL SELECT Statement

Lane Fonda April 07, 2020

Select all records from a given table?

Select * from table1;

Select column1 and column2 from a given table?

select column1, column2 from table1;

Practical SELECT statement example:

Table name: Contacts
Columns: ID, FirstName, LastName, Address, Country, City, Email

select ID, FirstName, LastName, Address, Country, City, Email
from Contacts;