Tuesday, October 4, 2011

Select Top Second Salary

 1. To find exact second salary
         select max(salary) from jos_emp where salary < (select max(salary) from jos_emp)
2. To find all second salary
         select salary from jos_emp where salary=(select max(salary) from jos_emp where salary < (select max(salary) from jos_emp)).
Posted by at
Labels:

1 comment:

  1. AnonymousOctober 4, 2011 at 5:36 AM

    How find max second salary without using sub-query?

    by

    PhpAndAll

    ReplyDelete

Subscribe to: Post Comments (Atom)