Retrieving Data with SELECT Statement

Retrieving Data with SELECT Statement - SQL Tutorial In Sinhala - Part 2

 Hits: 935

In this Video, you will learn :

  • SHOW TABLES - View list of Tables
  • DESCRIBE - View Table Structure
  • SELECT - Select Records
  • AS - Change column/table temporarily
  • ORDER BY - Sort output (Ascending)
  • DESC - Change sort direction (Descending)
  • DISTINCT - Select unique values
  • LIMIT - Limit number of records in the output
  • OFFSET - Selecting a range of output

Download Exercise File with SQL Database:
https://www.bestjobslk.com/download.php?v=Ur3q2ruqkC4


Categorised Under:
Structured Query Language