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.