Hi. This is dicussed here:
http://www.mysql.com/doc/G/r/Group_by_functions.html (after the function list) http://www.mysql.com/doc/E/x/Examples.html (see the subsections) Bye, Benjamin. On Sat, Nov 24, 2001 at 11:01:26PM +0530, [EMAIL PROTECTED] wrote: > Hello Everyone, > > I wants to find the max. date and Login status of employee for Attendance > table. > The qurey runs fine but it shows me the wrong status. > > select max(a.dAtt_Date),a.nLog_Status from tbl_attendance a,tbl_attendance b > where a.nEmp_id = 1 and a.nLog_Status = b.nLog_Status > group by b.nEmp_id [...] -- [EMAIL PROTECTED] --------------------------------------------------------------------- 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