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
- 7949 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 varoius components of physical database structure of oracle database?
Display those managers salary greater than the average salary of his employees?(Based on oracle standard Emp table)
Can we create index on views?
19 Answers CTS, Syntel, TCS,
What to do if dba lost the system password?
We need to compare two successive records of a table based on a field. For example, if the table is CUSTOMER, and the filed is Account_ID, To compare Account_IDs of record1 and record2 of CUSTOMER table, what can be the query ?
hello friends Im doing my final year engineering in B.Tech.. one of uncle said he can provide job in his company if im good in database management. but i have only basic knowledge about database, so like to join database management course in good intuition. so friends kindly help me to get good intuition because its my future.
Can a parameter be passed to a cursor?
Compare and contrast between sql and sql server and explain its various functions?
How remove data files before opening a database?
What are the roles of dba?
Explain about the analyze command in oracle?
what are the mandortary parameters required for cuncurrent program definition in oracle apps R12?
Oracle General 
