OraFAQ Forum: SQL & PL/SQL » Retrieve Ton N rows using aggregate functions.(merged 3)

Home » SQL & PL/SQL » SQL & PL/SQL » Retrieve Ton N rows using aggregate functions.(merged 3)

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

Retrieve Ton N rows using aggregate functions.(merged 3) [message #384883]

Thu, 05 February 2009 11:44

vjeedigunta
Messages: 201
Registered: March 2005
Location: Hyderabad

Senior Member

02/05/2009 ALERTS@ Xe> select metric_name, count(*) from main_alert group by metric_name order by 2 desc ;

METRIC_NAME COUNT(*)
---------------------------------------------------------------- ----------
Response 249
Database Limits 245
User Block 215
Tablespaces Full 189
Filesystems 174
User-Defined SQL Metrics 150
Alert Log 134

how to make it retrieve only top 5.

Thanks in advance,
VJ

Report message to a moderator

Re: Retrieve Ton N rows using aggregate functions.(merged) [message #384889 is a reply to message #384883]

Thu, 05 February 2009 11:56

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

There is no difference with another top N question, just put your query in an inline view, for instance.

Regards
Michel

Report message to a moderator

Re: Retrieve Ton N rows using aggregate functions. [message #384894 is a reply to message #384883]

Thu, 05 February 2009 12:05

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
So we can help you.

This is a FAQ so use SEARCH

Report message to a moderator

Previous Topic:	SQL plus report in excel format
Next Topic:	pl/sql Optimization

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Feb 11 05:52:31 CST 2025