Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 368196 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
What is latest version of sql?
Can we write ddl statements in functions?
What are some predefined exceptions in pl/sql?
What is join view in sql?
How can you tell the difference between an index and a view?
What do you understand by case manipulation functions?
how to concatenate two character strings? : Sql dba
What is anonymous block in sql?
Are subqueries better than joins?
What is dml statement?
How does sql store data?
How can you maintain the integrity of your database on instances where deleting an element in a table result in the deletion of the element(s) within another table?
What is trigger in pl sql?
How many joins in sql?
Can two tables have same primary key?
