⟩ How to find out nth highest salary from emp table?
SELECT DISTINCT (a.sal) FROM EMP A WHERE &N = (SELECT COUNT (DISTINCT (b.sal)) FROM EMP B WHERE a.sal<=b.sal);
For Eg:-
Enter value for n: 2
SAL
---------
3700
SELECT DISTINCT (a.sal) FROM EMP A WHERE &N = (SELECT COUNT (DISTINCT (b.sal)) FROM EMP B WHERE a.sal<=b.sal);
For Eg:-
Enter value for n: 2
SAL
---------
3700
What are phetom item? How are they user in business case?
What setups are done in WIP?
Which type of BOM is not used in WIP?
What is oracle apps project planning?
When the Internal Requisition will get generate if I define an OSP operation in sequence 30. 10 & 20 will be other than OSP operations?
What is indented BOM?
What are the master datas in Manufacturing process of Oracle Apps?
Tell me Is there a way to update schedule ship date for all lines of SO in one go?
IF user wants to ship the lines in single delivery when there are different delivery id created for a Sales order, then what process has to be followed?
What are the attributes we need to define for BOM to raise configuration sales order?