Interested to Buy Any Domain ? << Click Here >> for more details...
Query to get max and second max in oracle in one query ?
- 34 Answers
- 64499 Views
- CTS, Keane India Ltd, TCS, Wipro, I also Faced
- E-Mail Answers
Answer Posted / shashank yadav
Select Max(sal) from emp
where sal < any (select sal from emp);
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
How do you tell what your machine name is and what is its IP address?
Name the three major set of files on disk that compose a database in Oracle?
How to create a new table by selecting rows from another table?
What are a query and state the different types of queries and their uses?
Difference between hot backup vs. Cold backup?
Her departmandaki isçilerden empno' su ikinci sirada olan isçilerin empno, deptno, hiredate, sira_no bigilerini döndüren sorguyu yaziniz?
What is the meaning of recursive hints in oracle?
Will you be able to store pictures in the database?
How much memory your 10g xe server is using?
What is an external table?
What to do if dba lost the system password?
What is a user role in oracle?
hello friends Im doing my final year engineering in B.Tech.. one of uncle said he can provide job in his company if im good in database management. but i have only basic knowledge about database, so like to join database management course in good intuition. so friends kindly help me to get good intuition because its my future.
How to load data from external tables to regular tables?
Differentiate between function and procedure in oracle.
