Forum Replies Created

Viewing post 31 (of 31 total)

  • RE: how can i get 2nd or 3dr highest salary

    select distinct(sal) from emp where sal >= (select max(sal) from emp where

    sal <(select max(sal) from emp where sal< (select max(sal) from emp)))

    The following Query will display emps...

Viewing post 31 (of 31 total)