Hi, I have a table SalaryInfo as below
Salary | Department | Level 500000 | R&D | Director 30000 | Maintenance| Groundsman ...... I want to know what level in each department makes the highest salary and how much that salary is? Something like: SELECT Salary, Level, Department FROM SalaryInfo WHERE Salary=Max(Salary) Would using MySQL 4.1 that has support for nested select help my case? Thanks in advance prashant -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]