I have a simple query problem,

If I write following query it works fine

Select max(hiredate), deptno from emp
group by Deptno;

It gives me three record which is fine, Now I also want the Sal and empno of the records, How Do I do it?

Thanks in advance

[Edited by irehman on 01-15-2002 at 11:15 PM]