Hi all
I have a data in the table, For example emp table and empno column. What I need is I want to order by empno and then select the first empno sorted empno.
e.g:

Before order by
9999
6666
7777

After order by
6666
7777
9999

Now I want the first sorted row only (6666) NOT (9999). What query I will write to get this result.

Thanks