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 |
waht is the difference between primary key and super key?
Difference between sub query and nested query ?
19 Answers Keane India Ltd, TCS,
What is the scope of a local variable?
What is blob datatype?
What is the difference between formal parameters and actual parameters?
How can I create database in oracle?
Is java required for oracle client?
How to check database size in Oracle?
What is the difference between post-database commit and post-form commit?
How to use "for" statements in oracle?
How do you get nicely formatted results from an oracle procedure that returns a reference cursor?
How to Identify the previously inserted/updated records in already populated table.