Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 373196 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
Why do you partition data?
What is the reports view in oracle sql developer?
How many joins can you have in sql?
How to fetch values from testtable1 that are not in testtable2 without using not keyword?
What is a join query?
What is substitution variable?
who introduced sql?
Why do we need unique key in a table?
what are all the different normalizations? : Sql dba
What are the types of variable use in pl sql?
What type of database is cloud sql?
how can we transpose a table using sql (changing rows to column or vice-versa) ? : Sql dba
What is the max nvarchar size?
How to execute a stored procedure?
how to convert numeric values to character strings? : Sql dba
