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
- 7839 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
How to find out what oracle odbc drivers are installed?
How to concatenate two text values in oracle?
What is flashback in Oracle?
Can we insert data in view oracle?
> CREATE OR REPLACE FUNCTION FACTORIAL_1(factstr varchar2 ) 2 RETURN NUMBER AS 3 new_str VARCHAR2(4000) := factstr||'*' ; 4 fact number := 1 ; 5 BEGIN 6 7 WHILE new_str IS NOT NULL 8 LOOP 9 fact := fact * TO_NUMBER(SUBSTR(new_str,1,INSTR(new_str,'*')-1)); 10 new_str := substr( new_str,INSTR(new_str,'*')+1); 11 END LOOP; 12 13 RETURN fact; 14 15 END; explanation Above program?
Can we call procedure inside function in oracle?
What are the ways tablespaces can be managed and how do they differ?
What is key preserved table?
How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?
What is the relation of a user account and a schema in oracle?
Can we save images in a database and if yes, how?
How to define default values for formal parameters?
Which are the five query types available in oracle?
What is a snapshot in oracle database?
How to sort output in descending order in oracle?
