Home » SQL & PL/SQL » SQL & PL/SQL » extract from a table the 5 highest totals based upon a category
extract from a table the 5 highest totals based upon a category [message #249925] Fri, 06 July 2007 09:46 Go to next message
nfjints
Messages: 2
Registered: June 2007
Junior Member
Hi Everyone;

I'm pretty new at this SQL stuff & I've tried a search on the board to see if there was anything that I'm trying to do but with no success.

Here are my columns
fom_code,
thepy_cd,
grand_total

I would like to create another table and extract each of the top 5 highest by grand_total,thepy_cd,fom_code


Thanxs



Re: extract from a table the 5 highest totals based upon a category [message #249927 is a reply to message #249925] Fri, 06 July 2007 09:47 Go to previous messageGo to next message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
>I'm pretty new at this SQL stuff
It appears you are also new on how to us SEARCH capabilities both on this forum & GOOGLE.
Re: extract from a table the 5 highest totals based upon a category [message #249954 is a reply to message #249925] Fri, 06 July 2007 10:40 Go to previous messageGo to next message
nfjints
Messages: 2
Registered: June 2007
Junior Member
I'm asking for help not sarcasm.
Re: extract from a table the 5 highest totals based upon a category [message #249958 is a reply to message #249925] Fri, 06 July 2007 10:46 Go to previous message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/forum/?SQ=d125fea959a34e2650f91f58c235dfc7&t=search&srch=top+n&btn_submit=Search&field=all& forum_limiter=&search_logic=AND&sort_order=DESC&author=

>I'm asking for help
Why can't/won't you help yourself?
Previous Topic: Error exporting SQL report to Excel - Stack Empty
Next Topic: decoce of two columns
Goto Forum:
  


Current Time: Mon Dec 05 04:52:16 CST 2016

Total time taken to generate the page: 0.11011 seconds