5. Display full details for the creditor/s who has received
the single largest payment. Do not use a table join or set
operator anywhere in your query.
Answers were Sorted based on User's Feedback
Answer / er mahesh shiv gaur
SELECT MAX(SALARY) FROM (SELECT FIRST_NAME,SALARY,FROM EMP
ORDER BY SALARY DESC) WHERE ROWNUM<=1 GROUP BY
FIRST_NAME,SALARY;
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / srikanth
select *from <TN>
where sal=(select max(sal) from <TN>);
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / devraj
Select * From cust_data Where trxn_type = 'CR' And sal =
(Select max(sal) From cust_data) And Rownum = 1;
Is This Answer Correct ? | 2 Yes | 2 No |
Answer / ajit
select *
from ( select sal from emp order by sal desc)
where rownum <= 1
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / rajeev kumar
select max(salary) from <TN> where salary not in(select max
(salary) from <TN>)
salary->field name
Is This Answer Correct ? | 3 Yes | 5 No |
Answer / aswini
select * from <table_name> where salary in(select max
(salary) from <table_name>);
Is This Answer Correct ? | 0 Yes | 2 No |
various types of hints and their usage
If any one has information regarding interview of NIC (National Informatics Centre),it would be of great help...
What is mean by Program Global Area (PGA) ?
 What are the oracle DML commands possible through an update strategy?
What are the common oracle dba tasks?
How do I uninstall oracle 11g?
How to define an anonymous procedure without variables?
How can you tell how much space is left on a given file system and how much space each of the file systems subdirectories take-up?
Give the different types of rollback segments.
What are main difference between Stored Procedure and Functions.
6. Display the client name and order date for all orders using the traditional method.
What are temporal data types in oracle?