Re: SQL Question, first 50 of a query
From: Hadar Paiss <hpaiss_at_netvision.net.il>
Date: 1996/05/25
Message-ID: <31A6E8CC.23F4_at_netvision.net.il>#1/1
Date: 1996/05/25
Message-ID: <31A6E8CC.23F4_at_netvision.net.il>#1/1
Michael Brodesky wrote:
>
> I am trying to do the top50 in sql that is provided by
> access, but in oracle 7.2. Anyone know how to do this?
> Also is there a way to rename a column in a table?
>
> Michael
- There is no way to rename a column in a table but using: create table ... as select ...
- You can get the top 50 using something like: select ename,sal from emp a where 50 < (select count(*) from emp b where a.sal > b.sal)
Hadar Paiss Received on Sat May 25 1996 - 00:00:00 CEST