find out the third highest salary?
Answer Posted / anish nama
select Max(salery) from salery where salery IN( select
top N salery from salery order by salery asc)
Is This Answer Correct ? | 1 Yes | 6 No |
Post New Answer View All Answers
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
Explain the different normalization forms?
What is oracle database 10g express edition?
How do I spool to a csv formatted file using sqlplus?
What is oracle data type?
Differentiate between post-database commit and post-form commit?
Explain the use of rows option in imp command.
How to load data from external tables to regular tables?
What is a nvl function?
How to delete an existing row from a table in oracle?
How to use "in" parameter properly?
What is analyze command used for?
How to call a stored function in oracle?
What is the relationship among database, tablespace and data file?
Difference between cartesian join and cross join?