find out the third highest salary?
Answer Posted / mamta
select rownum as maxsal,sal
from (select sal from emp order by sal desc)
where rownum <4
Is This Answer Correct ? | 0 Yes | 6 No |
Post New Answer View All Answers
How can we delete duplicate rows in a table?
Please explain me all types of Data models. Also give me the details if each model can have other name.for example:schematic data model is also known as conceptual data model and entity relation data model.
What's dateware house and what's clustor with practicle example
how to handle exceptions in post production
Design database draw er diagram for a certain scenario ?
What is the data type of dual table?
What are the original export and import utilities?
How to run queries on external tables?
What is truncate oracle?
What happens if variable names collide with table/column names?
What is different types of joins?
how to clone 9i Database on to 10g Database.
Can you have more than one content canvas view attached with a window ?
How to export your connection information to a file?
How to retrieve data from an explicit cursor?