Re: SQL question

> Using inline views solves this problem quite easy. Although we're not able
> to order in inline views before Oracle 8 we can distinguish the top 3
> salaried people by using nested inline views and the group by function.
>
> The first inline view is used for distinguishing the best salary
 (top1_sal)
> for each department. In the second inline view we select the second best
> salary (top2_sal); in the third inline view we select the third best
 salary
> (top3_sal). By comparing the salaries with these inline views we get the
> desired result without using explicit ordering, rownums or functions.
>
> The statement below wil answer your question!
>
> Good luck,
>
> Nellie
>

Well, thats fine, but if nedeed to select top 2000 and more employers. That will be query with 2000 or more inline views;) Received on Wed Nov 08 2000 - 04:47:56 CET