Re: Sort data in asc as well as desc in 1 query

ambalikavikash_at_yahoo.co.in (Ambalika) wrote in message news:<247bcd5.0307102257.4155a7a9_at_posting.google.com>...
> Hi All!
>
> Can u please guide me as to how do I select data (eg. sal) both in
> ascending and descending order in one query?
>
> Thanks!

hi again!

I did work out the solution which was quite simple. Given below is the query. More efficient solutions are welcome!

Thanks!

SELECT A.SAL,B.SAL
   FROM (select rownum ind,SAL

           FROM (SELECT SAL FROM EMP ORDER BY SAL ASC)
           where rownum <= (SELECT COUNT(EMPNO) FROM EMP)) a,
        (select rownum ind,SAL
           FROM (SELECT SAL FROM EMP ORDER BY SAL DESC)
           where rownum <= (SELECT COUNT(EMPNO) FROM EMP)) b