How to Select second Maximum salary in a Table ?
- 13 Answers
- 13511 Views
- Oracle, I also Faced
- E-Mail Answers
Answer Posted / guest
select max(sal) from Table
where sal not in(select max(sal) from Table);
| Is This Answer Correct ? | 20 Yes | 3 No |
Post New Answer View All Answers
What privilege is needed for a user to insert rows to tables in another schema?
How to download oracle database 10g xe?
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.
How to count duplicated values in a column in oracle?
can u plz provide me oca sql dumps please i need them
What is BBED in Oracle?
How to execute a stored procedure in oracle?
What is a sub query? What are its various types?
What is meant by an index?
How remove data files before opening a database?
What is user managed backup in Oracle?
What is raw datatype?
What is an oracle tablespace?
What is columnar storage what is the advantage?
Is there any function in oracle similar like group_concat of mysql?
