Interested to Buy Any Domain ? << Click Here >> for more details...
How to Select second Maximum salary in a Table ?
- 13 Answers
- 15207 Views
- Oracle, I also Faced
- E-Mail Answers
Answer Posted / sephali
select sal, rownum
from (select sal from table
order by sal desc)
where rownum=2
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
what is the scripts in data base?
How many types of cluster table in Oracle?
What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?
How to define a data field as not null?
What is a snapshot log?
How can I get column names from a table in oracle?
How can we find out the current date and time in oracle?
How do you get nicely formatted results from an oracle procedure that returns a reference cursor?
How do I spool to a csv formatted file using sqlplus?
What are a query and state the different types of queries and their uses?
What are the differences between number and binary_float in oracle?
Explain user account with reference to oracle.
What is a oracle database?
How to delete all rows a table in oracle?
How will you write a query to get a 5th rank student from a table student_report?
