Re: SQL Question, first 50 of a query
From: Josef Scheichenzuber <scheich_at_gch.med.uni-muenchen.de>
Date: 1996/05/23
Message-ID: <scheich-2305961123340001_at_gch04a.gch.med.uni-muenchen.de>#1/1
Date: 1996/05/23
Message-ID: <scheich-2305961123340001_at_gch04a.gch.med.uni-muenchen.de>#1/1
In article <4ntehe$o8j_at_kadath.zeitgeist.net>, michael_at_lazlo.steam.com (Michael Brodesky) wrote:
> I am trying to do the top50 in sql that is provided by
Try the following to get the top50 from your_table:
select * from your_table where rownum <= 50;
> access, but in oracle 7.2. Anyone know how to do this?
> Also is there a way to rename a column in a table?
Josef. Received on Thu May 23 1996 - 00:00:00 CEST