how to find the n'th highest salary from emp ?

Answer Posted / sunil panghal

select max(salary) from employees

Is This Answer Correct ?    1 Yes 16 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can the query output be sorted by multiple columns in oracle?

574


What is a snapshot log?

564


what is meant by magic query

1775


Is there a function to split a string in plsql?

570


why dont we assign not null constraint as table level constraint.

2257






State the difference between a primary key and foreign key?

518


Explain what are the uses of rollback segment?

589


What is Redo Log Buffer in Oracle?

634


What is a procedure in oracle?

618


In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?

1787


How to execute the package in oracle?

572


Explain about achiever in sql?

584


What is merge statement used for?

570


Compare and contrast between sql and sql server and explain its various functions?

540


when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.

1477