Database Tutorial in Amharic Lesson 8 - Select Query

In this video I will show you
1. How to write basic select query from a single table.
2. How to filter out rows from select result.
3. How to order the result of a select query in Ascending or Descending order.

Query using *
SELECT * FROM Department

Query specifying columns:
SELECT Id, DepartmentName FROM Department

Query to filter out rows:
SELECT ID , DepartmentName FROM Department WHERE Id=1

Query to sort column in Descending order:
SELECT ID, DepartmentName FROM Department ORDER BY Id Desc

Query to sort column in Ascending order:
SELECT ID,DepartmentName FROM Department ORDER BY Id ASC