SQL*plus Query -- Very urgent

oh yes index the column

Oh, I get it - you didn't write want you meant:

"What I need is I want to order by empno and then select the first empno sorted empno. "

Where is deptno in all of this?

I invented deptno :D

Oh.

Select * from emp where empno in
(select min(empno) from emp);

Thanks you both,
I am still on the same page; Index is not possible for some reason. All I am looking if there is way I can resolve this issue. I suppose you have more power, ability, expert level and professional knowledge.

Thanks

I am sorry but your suppose is wrong :D

if you are using 7.3.4 is what you get :D

Honest to God, this works:

Select * from emp where empno in
(select min(empno) from emp);