Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 6 Answers
- 7940 Views
- Wipro, I also Faced
- E-Mail Answers
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 |
What is the difference between translate and replace?
structural difference between bitmap and btree index ?
Indexes in oracle ?
3 Answers Keane India Ltd, L&T,
21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.
Define Normalization with example?
What is the data pump export utility?
when i run my query on yesterday it is fast but today it is slow why?
 What are the oracle DML commands possible through an update strategy?
Can u make a synonym for deptno=10 only from emp table.
Anybody can tell me, how do we find second largest emp salary from emp table.. Thanks in advance ...
10 Answers Cognizant, ID, NTTF Nettur Technical Training Foundation, Sony, Verizon,
What are synonyms used for ?
What are the values that can be specified for OPTIMIZER_GOAL parameter of the ALTER SESSION Command ?
Oracle General 
