Re: MAX/DISTINCT in one query
From: Mario Zgela <mario_at_hnb.hr>
Date: 22 Dec 1998 12:12:01 GMT
Message-ID: <01be2da4$fa503700$236faaaa_at_mzgela>
Date: 22 Dec 1998 12:12:01 GMT
Message-ID: <01be2da4$fa503700$236faaaa_at_mzgela>
The problem could be solved using:
select emp_no,dept,salary from emp eq
where salary=(select max(salary) from emp es
where eq.dept=es.dept)
Mario Received on Tue Dec 22 1998 - 13:12:01 CET