How to Select second Maximum salary in a Table ?
Answer Posted / ranjith
select salary from table order by salaray desc limit 1,1
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What is columnar storage what is the advantage?
What is Virtual Private Database in Oracle?
What is merge in oracle?
What are the oracle differences between nvl and coalesce
Point out the difference between user tables and data dictionary?
What is the difference between I and G in Oracle?
How to estimate disk space needed for an export job?
Which dictionary tables and/or views would you look at to diagnose a locking issue?
I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.
What are the different pseudo commands? Explain in general?
State the difference between a primary key and foreign key?
What is the difference between translate and replace in oracle?
How to join two tables in a single query using oracle?
What is Undo Management Advisor in Oracle?
What is the difference between count (*), count (expression), count (distinct expression)?