Interested to Buy Any Domain ? << Click Here >> for more details...
Q) How to Find Max Date from each Group? (Asked in Infosys
(INFI)Interview)
- 4 Answers
- 8439 Views
- Infosys, I also Faced
- E-Mail Answers
Answer Posted / sudipta santra
select market_id, mkt_name, max(sale_dt)
from market
group by market_id, mkt_name;
Note: This is the only correct answer
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
material view and view disadvantages?
Is a rollback possible to any savepoint?
How to loop through a cursor variable?
How to export several tables together?
What would you do with an in-doubt distributed transaction?
What is the dynamic sql in oracle?
What are oracle functions?
I have some query regarding Report generation from Oracle Apps "PO module". I have to generate a report where table columns are as below: Vendor_name Invoice No PO Number Item_Quantity Value of Goods Date of Shipping Name_of_the_transport Date_of_receipt_issued. Now my questions is :from which table/column I can get the information of "Name_of_the_transport" column. Thanks in advance.
Explain the use of record length option in exp command.
What is recovery manager in Oracle?
Hi Can any one tell me what are the API's used in requisition import.
Please explain oracle data types with examples?
How to load excel data sheet to oracle database
How to create a stored function in oracle?
How to start a new transaction in oracle?
