...

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;




Note:

Database name should be present in database.

Example 1:



 SELECT CustomerName, City FROM Customers;


 SELECT * FROM Customers;



Example 2:



Online compiler