Home » SQL & PL/SQL » SQL & PL/SQL » Department wise max salary.
Department wise max salary. [message #232697] Mon, 23 April 2007 01:17 Go to next message
akkumar81
Messages: 144
Registered: February 2007
Location: india
Senior Member


Hi,

i want a query in Department wise max salary in atable.

name sal dept deptno
------------------------
martin 5000 cse 10

connors 3000 mech 20

linkam 7400 cse 10

guru 34000 mech 20

kumar 20000 civil 40

singh 12000 civil 30



i want max salary in each deptartment .PLease help me.

regards,

Arunkumar..










Re: Department wise max salary. [message #232705 is a reply to message #232697] Mon, 23 April 2007 01:25 Go to previous messageGo to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
- Read the sticky (first topic here, tips & tricks)
- Read the Oracle documentation.
- Search the board.
- Show us what you tried.

I urge others NOT to spoonfeed, but let the OP do some thinking on his own.

MHE
Re: Department wise max salary. [message #232712 is a reply to message #232697] Mon, 23 April 2007 01:29 Go to previous message
shanthkumaar
Messages: 156
Registered: February 2007
Location: india,chennai
Senior Member

hi,

maximum

regards
shanth
Previous Topic: Second and Third max sal
Next Topic: packages
Goto Forum:
  


Current Time: Wed Dec 07 10:55:36 CST 2016

Total time taken to generate the page: 0.14805 seconds