Re: MAX/DISTINCT in one query
From: Sunder <Sunder.nochilur_at_pcm.bosch.com>
Date: Wed, 16 Dec 1998 19:09:43 -0500
Message-ID: <759i8j$g0k$1_at_news.fr.internet.bosch.de>
Date: Wed, 16 Dec 1998 19:09:43 -0500
Message-ID: <759i8j$g0k$1_at_news.fr.internet.bosch.de>
[Quoted] [Quoted] Sunder wrote in message ...
Hello Group
I ahve a table employee
[Quoted] emp_num , dept, salary
I want to select the dept,empl_num and salary of the empl with max salary in each dept.
ex
emp no dept salary 1000 10 1000 1001 10 2000 1002 20 1500 1003 20 1100
The output of the query should be
emp no dept salary 1001 10 2000 1002 20 1500.
Can anybody tell me how this can be accomplished .
Sunder Received on Thu Dec 17 1998 - 01:09:43 CET