Re: second max value

Posted By: S.V.Srikanth at 08:15:18 on Friday the 13th of July 2007

This query is working SELECT MAX(EmpNum) AS Expr1 FROM EmpDetails WHERE (EmpNum NOT IN (SELECT MAX(EmpNum) FROM empdetails))

Reply to this comment

Name
Email
URL (optional)
Title of Comment
Comment
HTML Allowed:
a,code,strong,em
I would like to be e-mailed any response to my comment.