find out the second highest salary?
Answer Posted / kiran
select max(empsal) from emp where rownum<=2
| Is This Answer Correct ? | 24 Yes | 188 No |
Post New Answer View All Answers
How to create a stored program unit?
What are the differences between lov and list item?
What is a data dictionary and how can it be created?
How to convert a date to char in oracle? Give one example.
What are the arithmetic operations?
An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?
How many types of segments in Oracle?
How many categories of data types?
What is an oracle user role?
How to connect to oracle using service name instead of sid?
What do you understand by a database object? Can you list a few of them?
How to list all indexes in your schema?
you are a universe designer and report developer in BO, what type of information you gather from client?Briefly explain plz
How does Oracle guarantee data integrity of data changes?
What is Library Cache in Oracle?