Why 'Select' is called as DML statement ?

 Hi Gagan,

 

SQL Statements are divided int five different categories based on their categories as below:

Data definition language (DDL),

Data manipulation language (DML),

Data Control Language (DCL),

Transaction Control Statement (TCS),

Session Control Statements (SCS).

As SELECT is used to manipulate tables or records. So, SELECT is called as DML or Data manipulation language. In similar way CREATE is used to define and create the table or column structure so it is called as Data definition language (DDL).