Database Managment - Sql

Back to Course

Lesson Description

Lession - #1283 SQL Select

Used to select some or all columns.

Syntax for Select

//select two columns that is column1 and column2 from table.
SELECT column1, column2, ... FROM table_name;

//select all columns from table
SELECT * FROM table_name;


Database name should be present in database.

Example 1:

 SELECT CustomerName, City FROM Customers;

 SELECT * FROM Customers;

Example 2:

Online compiler