Order By is a keyword which is using for sort the table records either ascending or desending.For eg,for ascending,Select emp_name,emp_identity from emp order by emp_identity;Select emp_name...

contents or data of the table can be sorted by using clause ORDER BY  in SELECT statement.By default the table is in ASCENDING order.SYN: SELECT  * from [table name]    &...

DDL is used to create, alter and truncate
DML is used to insert, update, delete and drop

DDL means "Data Definition Language". SELECT, UPDATE, INSERT belong to DML, which is "Data Modification Language". DDL is all the other commands -- for example, CREATE TABLE.