SQL for Beginners Series

Session 5

Datatypes in SQL

YouTube Video Link:

SQL for Beginners Series

Session 4

Subsets of SQL

YouTube Video Link:

SELECT Command is categorized as Data Manipulation Language as it can modify the data while retrieving the data from database.

Aggregate functions can be used and we can generate the columns on the fly while selecting.

We can concatenate columns and modify the data.

Using order by we can also sort the the way we want. Hence SELECT is classified under DML Command.

Find Employees With Salary Lower Than Their Department Average

   Part - 13

Click below for you tube Answer

In the above query there are 3 parts:

Part 1: Deriving the average salary of the department

Part 2: Joining the tblEmployee table to the derived table on Department id

Part 3: Applying the filter condition to pick employees whose salary is less than average dept salary