Q) How to Find Max Date from each Group? (Asked in Infosys
(INFI)Interview)
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
How do we create privileges in oracle?
What is data file?
What is oracle sid?
Explain what are the uses of rollback segment?
Name the three major set of files on disk that compose a database in Oracle?
What is a package ? What are the advantages of package ?
How to start instance with a minimal initialization parameter file?
What is Reduced List of Values?
How to loop through data rows in the implicit cursor?
Is there a combination of "like" and "in" in sql?
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.
How do you find out from the RMAN catalog if a particular archive log has been backed-up?
How to define an anonymous procedure with variables?
What is key preserved table?
How to build data dictionary view an new database?