Why Select is DML statement in SQL?
DML - Data Manipulation Language
The purely read-only SELECT query statement is classed with the 'SQL-data' statements
The SELECT ... INTO form is considered to be DML because it manipulates (i.e. modifies) data.
SELECT Column1, Column2
INTO DestinationTable
FROM SourceTable
Copy Coumn1,Column2 From SourceTable to DestinationTable.
So Select is dml statement
Other DML Statement are
Insert, Update and Delete