What is the output of the following query ?
Query: select distinct dept from employees order by lname ;
query will get compiled or parsed without any errors but will not give any result.
in the result set deprtment names are displayed based on the ascending order of the lname coulmn values.
Query will give error during execution but will not produce any error during parsing stating ORDER BY items must appear in the select list if SELECT DISTINCT is specified.
None of the above.
Back To Top