Re: And the correct answer is?

You are wrong here. When you say "ORDER BY 1" it means you want to order by first column of resultset and "ORDER BY 2" = order by second column and so on.

Sandijs
OCP DBA,
Riga, Latvia

Originally posted by Mikito Harakiri
> "1" is just a constant function (or constant expression), so that
>
> SELECT empno, ename FROM emp ORDER BY 1
>
> must be equivalent to
>
> SELECT empno, ename FROM emp ORDER BY 2
>
> and to just
>
> SELECT empno, ename FROM emp

--
Posted via http://dbforums.com