Find out the 3rd highest salary?

Answer Posted / tathagoto

select sal from (select sal from salary order by sal desc)
where rownum <4;

Is This Answer Correct ?    1 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can we insert data into materialized view?

531


What is difference between ms sql and mysql?

484


Is it possible to create startup or shutdown trigger for on-schema?

595


Can we insert in view in sql?

574


How much does sql cost?

533






How can the performance of a trigger be improved?

601


write an sql query to find names of employee start with 'a'? : Sql dba

592


What is sql partition function?

626


i have some prob lem to tell me about my self in interview first round ...

1715


Is pl sql better than sql?

564


how to drop an existing index in mysql? : Sql dba

551


what are the different functions in sorting an array? : Sql dba

591


Why triggers are used?

565


How can a function retun more than one value in oracle with proper example?

594


Mention what are the benefits of pl/sql packages?

544