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
- 7646 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 are the ansi data types supported in oracle?
Why do we use coalesce function in oracle?
hai, I am searching job on Oracle10g and PL/sql,Unix... can any one send me resume format. an suggest me how to prepare.. ann books..
Can u make a synonym for deptno=10 only from emp table.
What is the difference between a user and a schema in oracle?
normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi
How to define a cusotmer as a supplier in ORACLE R12
How do I learn what codesets are available in oracle?
can a view be updated?
What is the quickest way to fetch the data from a table?
What is system tablespace?
How to Identify the previously inserted/updated records in already populated table.
Oracle General 
