how to retrieve a second max sal in a table of emp
thank u

select max(column1), max(column2) from table...

Is this what you are looking for? If not, please provide us with more information.

Select max(employeeid) from employees where employeeid != (Select max(employeeid) from employees)

Deepesh Jain
VB,VBA & .NET Specialist
Wiley Support Team

select max(Invoice_Amount) from Invoice where Invoice_Amount < (select max(Invoice_Amount) from Invoice)



---In this query we can get the second highest Invoice_Amount from Invoice table

select max(a.Projects_Posted_Amount) from Member a,Member b
where a.Projects_Posted_Amount < b.Projects_Posted_Amount