Question

In order to see the contents of the table 'Employee', by sorting the 'Empno' column, in ascending order which of the following query can be used *

select * from Employee where order by Empno asc;
select * from Employee order by Empno asc;
select * from Employee where orderby Empno ASC;

Answer 1

Answer:

select * from Employee where orderby Empno ASC;

Answer 2

Select from employe where orderby empno ASC