TO APPLY CONDITION IN A PARTICULAR QUERY AND ORDER BY CLAWS.

to apply condition WHERE command is used

syntax : SELECT*FROM TABLE NAME WHERE CONDITION;

for example to select coloumns from table employee_668 where salary is greater than or equal to 20000

SELECT*FROM EMPLOYEE_668 WHERE SALARY>=20000;

ORDER BY CLAWS

FOR ASCENDING ORDER

SELECT COLOUMN NAME FROM TABLE NAME WHERE CONDITION ORDER BY COLOUMN NAME;

FOR DESCENDING ORDER

SELECT COLOUMN NAME FROM TABLE NAME WHERE CONDITION ORDER BY COLOUMN NAME DESC;