Home » SQL & PL/SQL » SQL & PL/SQL » NEED TO SHOW THE TOP 5 DATA
NEED TO SHOW THE TOP 5 DATA [message #194983] Tue, 26 September 2006 07:14 Go to next message
yadav.bhupender
Messages: 6
Registered: February 2006
Junior Member
hello friends,

i have a problem that i am sharing with u.

Please help me to do this.

i am attaching a excel which have two sheet's name like data and result.

result sheet contain the data that i need using sql query.

i am showing here the top five client of every executive with the using of amount field.

if u understand my query then reply me soon...

i am waiting ur response............



Regards,

Bhupender Yadav
  • Attachment: DATA.xls
    (Size: 16.50KB, Downloaded 162 times)
Re: NEED TO SHOW THE TOP 5 DATA [message #194984 is a reply to message #194983] Tue, 26 September 2006 07:20 Go to previous messageGo to next message
JSI2001
Messages: 1016
Registered: March 2005
Location: Scotland
Senior Member
Search the forums for 'TOP N'. This question has been asked many many times
Re: NEED TO SHOW THE TOP 5 DATA [message #194991 is a reply to message #194984] Tue, 26 September 2006 08:02 Go to previous message
ehegagoka
Messages: 493
Registered: July 2005
Senior Member
hi!
check for analytic functions, using RANK or dense_rank (just check for the syntax.
Previous Topic: Order of retreival from table
Next Topic: SQL question
Goto Forum:
  


Current Time: Mon Dec 05 11:12:44 CST 2016

Total time taken to generate the page: 0.08540 seconds