find out the second highest salary?
Answer Posted / v.karthikeyan
select * from emp
where &n-1=(select count(distinct(sal)) from emp b
where emp.sal<b.sal)
Is This Answer Correct ? | 62 Yes | 30 No |
Post New Answer View All Answers
while i take backup using ibm tsm the following errors occurred: rman-03009 ora-19513 ora-27206 ora-19502 ora-27030 ora-ora19511
What is oracle used for?
How to retrieve data from an cursor to a record?
What is a cursor and what are the steps need to be taken?
Which is faster join or subquery in oracle?
How to load data through external tables?
How can we delete duplicate rows in a table?
Compare and contrast between sql and sql server and explain its various functions?
What are the uses of Database Trigger ?
What is the difference between translate and replace?
what is the need of indexing topic in oracle? where do we use in a Java project? any other option other than using this to get the same result where we use indexing ?
What are the different types of synonyms?
What is the difference between substr and instr?
What are the different types of record groups in oracle? Explain each of them
Explain the difference between sap and oracle?