6. Summarising and Grouping: Step 4

Demo

Find the employee whose name is first in the alphabet (2).

In MySQL the previous task can also be achieved using the following:

SQL

SELECT ename FROM emp ORDER BY ename LIMIT 1;

Output

ename
ADAMS

Progress

Proceed to Next step