Re: SQL Question
From: (wrong string) æ <zjuric_at_hotmail.com>
Date: 2000/07/17
Message-ID: <8kus68$hnv$1_at_as102.tel.hr>#1/1
SQL*Plus: Release 3.3.2.0.2 - Production on Mon Jul 17 12:51:36 2000
Received on Mon Jul 17 2000 - 00:00:00 CEST
Date: 2000/07/17
Message-ID: <8kus68$hnv$1_at_as102.tel.hr>#1/1
> select * from (
> select * from table_name order by count desc )
> where rownum <=10;
>
Sorry,
Probably works with v.8.x by in my case doesn't help... (see version bellow) :-(
SQL*Plus: Release 3.3.2.0.2 - Production on Mon Jul 17 12:51:36 2000
Copyright (c) Oracle Corporation 1979, 1994. All rights reserved.
Connected to:
Oracle7 Server Release 7.2.2.4.0 - Production Release
PL/SQL Release 2.2.2.3.0 - Production
Received on Mon Jul 17 2000 - 00:00:00 CEST