Find out the 3rd highest salary?
Answer Posted / umesh naik
select max(amount) from (
select distinct amount from temp123
where rownum <= 3
)
| Is This Answer Correct ? | 1 Yes | 8 No |
Post New Answer View All Answers
How do I use google cloud in sql?
Why we use joins in sql?
Can you have more than one key in a database?
How do I create a sql database?
What is a stored procedure in sql with example?
in oracle 10g sw after compiling procedure how to pass parameter values ,if we (v_empid out number)how to give empid after successful compilation program.This site exact suitable for 10g with respect to question & answer same format , im trying sql browser & sql command prompt using exec procedure name & respective parameters.
what is the difference between union and union all? : Sql dba
How do I edit a stored procedure?
What is the use of prepared statement?
How many commands are in sql?
Can you skip header records while loading? : aql loader
How can you save or place your msg in a table?
What is embedded sql in db2?
Why join is faster than subquery?
How do I view output in sql developer?