find out the second highest salary?
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
How to drop a stored function?
What are ddl statements in oracle?
master table and child table performances and comparisons in Oracle ?
What is PL/SQL ?
Can we write dml statement in function in oracle?
In which language oracle has been developed?
What are the restrictions in a oracle read only transaction?
i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?
How to create tables for odbc connection testing?
How to turn on or off recycle bin for the instance?
Is there a function to split a string in plsql?
what are actual and formal parameters?
Use of an integrity constraint is better to validate data. Explain
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 lock and unlock a user account in oracle?