Interested to Buy Any Domain ? << Click Here >> for more details...
find out the second highest salary?
- 55 Answers
- 87791 Views
- Cognizant, Nucsoft, Oracle, TCS, Wondersoft, I also Faced
- E-Mail Answers
Answer Posted / sandeep
select max(sal) from emp where sal<(select max(sal) from emp);
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What are the restrictions on external table columns?
Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.
How different is ms access and oracle?
Explain enable novalidate constraint.
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.
How to execute the package in oracle?
What is the quickest way to export a table to a flat file?
Why does Oracle not permit the use of PCTUSED with indexes?
How to turn on or off recycle bin for the instance?
What is oracle rownum?
What is the parameter mode that can be passed to a procedure?
Is postgres faster than oracle?
How to sort the query output in oracle?
What is the difference between online and offline backups?
How to shutdown your 10g xe server from command line?
