Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 368662 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 / rajkishore bagwan
simplest method ----
select salary
from employees
order by salary desc
offset n-1 rows fetch next 1 rows only
(replace n with any number it will give you the nth highest salary)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Does sap use sql?
Explain about various levels of constraint.
Can we insert delete data in view?
What is primary key and foreign key?
Differentiate between syntax and runtime errors.
What is trigger explain it?
Lookups are a key component in sql server integration services (ssis). Explain its purpose?
Does execute immediate commit?
What is pls integer?
Can instead of triggers be used to fire once for each statement on a view?
What are aggregate functions in sql?
What are the advantages of sql?
What is difference between stored procedure and trigger?
What is the difference between a subquery and a join?
Explain the purpose of %type and %rowtype data types?
