Hi I got a problem with max function
select a.cemp_firstname,sum(nsalary_value),max(nsalary_status),max(dstatus_date) from employeemaster as a,empsal as s where a.nemp_id = s.nemp_id group by dstatus_date This query shows me two records . But my requriment is according to the max -> salary status and max -> salary status date according to the employee id. My requriment is show only single for particular employee. how can it is possible. pl. help, Manish --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php