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
- 7932 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 functional dependecy and multilevel dependency?
How can we find out the duplicate values in an oracle table?
How to load data through external tables?
State the difference between a primary key and foreign key?
What are the arithmetic operations?
what is difference between cartesian join & cross join even they give same result?
Which environment variables are absolutely critical in order to run the OUI?
How can I get column names from a table in oracle?
what is IDE,DMV in sql server?
how to store only time in a data base table
in account table account type amount ac1 credit 300 ac2 debit 5000 ac3 credit 3000 ac1 debit 4000 ac3 debit 2000 ac2 credit 4000 write a query how to get sum of credit & sum of debit
From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.
Oracle General 
