find out the second highest salary?
Answer Posted / nusrath sultana
select * from emp
where &n=(select count(distinct(sal)) from emp b
where emp.sal<=b.sal)
Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
What is meant by joins?
normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi
How do we display rows from the table without duplicates?
How to export several tables together?
How to convert raw data type into text in oracle? Explain
How to create an initialization parameter file?
What are the differences between interval year to month and interval day to second?
What is an oracle data file?
What is proxy method?
what are archived logs?
What are the ways tablespaces can be managed and how do they differ?
How to insert a new row into a table in oracle?
Difference between oracle's plus (+) notation and ansi join notation?
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 ?
How to define a cusotmer as a supplier in ORACLE R12