Interested to Buy Any Domain ? << Click Here >> for more details...
How to Select second Maximum salary in a Table ?
- 13 Answers
- 15225 Views
- Oracle, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 9896012055
select * salary from table < select max(salary) from table
order by salary;
| Is This Answer Correct ? | 0 Yes | 4 No |
Answer / havyas
select sal from table where rownum = 2 order by sal desc
| Is This Answer Correct ? | 1 Yes | 13 No |
1.how to extract the second highest salary from emp table having sal as a column which contains the salary of all employee of an organisation.
What is a cursor in oracle?
Can sub procedure/function be called recursively?
write a query to dispaly those name who is more than one in student table? example- in a student table sandeep kumar comes 4 times, rakesh kumar comes 2 times, ajit kumar comes 1 times so query will display sandeep kumar and rakesh kumar single times.
3. Adapt your query in (2) above so that only post codes with more than twenty orders are displayed.
Why should I use oracle database?
how do u know the total no of rows in a table?
How to add a new column to an existing table in oracle?
How to do paging with oracle?
What suggestions do you have to reduce the network traffic?
How to use "while" statements in oracle?
can u plz provide me oca sql dumps please i need them
Oracle General 
