Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 361362 Views
- CIS, Cognizant, Cosmosoft, DAS, EDS, GreenTech, HOV Services, IBM, Infosys, National Institute of Science and Technology, Patni, Persistent, Polaris, TCS, Wipro, Yardi, Zensar, I also Faced
- E-Mail Answers
Answer Posted / abhijit banik
To get the n-th highest salary from employee table in oracle-10g
--------------------------------------------------------------
select min(salary)
from
(
select rownum rn, salary
from
( select distinct(salary) from employee order by salary desc )
)
where rn<=&n+1
| Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
Is left join same as inner join?
What is a composite primary key?
What is nvarchar max in sql?
What are the different types of triggers?
What is a schema? How is it useful in sql servers?
How delete a row in sql?
how to shut down the server with 'mysqladmin'? : Sql dba
Can a foreign key be a duplicate?
what is collation? : Sql dba
How do I view a sql database?
Explain the insert into statements in sql?
Which language is used in sql?
Is coalesce faster than isnull?
Is not equal in sql?
Determine if oracle date is on a weekend?
