OraFAQ Forum: SQL & PL/SQL » Getting number of records in oracle 8.0.5

Home » SQL & PL/SQL » SQL & PL/SQL » Getting number of records in oracle 8.0.5

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Getting number of records in oracle 8.0.5 [message #1793]

Thu, 30 May 2002 06:03

Sudhakar
Messages: 34
Registered: May 2002

Member

Hi I am facing a problem in getting requisite number of records after sorting a date field. I am entering the following query. Can any body tell me what is wrong with it. I can able to work the same in oracle 8.1.7.
*****************************
SELECT a.CHANGE_TIME FROM
(select CHANGE_TIME from vpps_change_log t ORDER BY t.CHANGE_TIME DESC )a WHERE ROWNUM <= 10
***************************************
Thanks in advance

Sudhakar

Report message to a moderator

Re: Getting number of records in oracle 8.0.5 [message #1795 is a reply to message #1793]

Thu, 30 May 2002 08:39

Todd Barry
Messages: 4819
Registered: August 2001

Senior Member

For pre-8i releases (like 8.0.5), you need to use this approach:

select change_time
  from vpps_change_log a
 where 10 >= (select count(distinct change_time)
                from vpps_change_log b
               where b.change_time >= a.change_time)
 order by change_time_desc;

Report message to a moderator

Previous Topic:	Re: about Create table
Next Topic:	about pls_integer

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue May 21 05:51:28 CDT 2024