Why 'Select' is called as DML statement ?

Question

Dharmraj Thakur · Answer

Hi Gagan Hope you are doing well. First of all do not confuse word with Manipulation . It means play with data which means retrieve store modify delete insert update copy etc. Guys you cannot say select statements used for only retrieve the data  it is used to manipulate the data . 1. Data aggregation and grouping is also data manipulation 2. Data convertion or type conversion is also data manipulation 3. Condition retrieving of data is also data manipulation 4. Working with CTE is also can be data manipulation 5. Many Other reasons can be include Let me explain how select statement can change data of database tables... Example: SELECT * INTO tb_Table2 FROM tb_Table1 -- this statement will copy all the records from tb_Table1 to tb_Table2

Suraj Kumar · Answer

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).