Query Help
Posted by:
Vis hwa
Date: April 23, 2009 09:08AM
Hi,
Can anyone help me on a query for retrieving data as follows
I have a column with data as shown below
Column_Name
1
2
1
1
2
3
I need a query where i want to display only the highest repeating row (i.e, 1 )
Also another query that displays only second highest repeating row (i.e, 2 ).
Thanks
Subject
Written By
Posted
Query Help
April 23, 2009 09:08AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.