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
Can we insert data into materialized view?
What is difference between ms sql and mysql?
Is it possible to create startup or shutdown trigger for on-schema?
Can we insert in view in sql?
How much does sql cost?
How can the performance of a trigger be improved?
write an sql query to find names of employee start with 'a'? : Sql dba
What is sql partition function?
i have some prob lem to tell me about my self in interview first round ...
Is pl sql better than sql?
how to drop an existing index in mysql? : Sql dba
what are the different functions in sorting an array? : Sql dba
Why triggers are used?
How can a function retun more than one value in oracle with proper example?
Mention what are the benefits of pl/sql packages?