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
- 8239 Views
- Infosys, I also Faced
- E-Mail Answers
Answer Posted / suman rana
select market_id, mkt_name, sale_dt from (
select market_id, mkt_name, sale_dt, max(sale_dt) over
(partition by market_id, mkt_name ) Max_sale_dt
from market )
where sale_dt = Max_sale_dt
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what is Single Byte Overhead...?
What are the general rules on data consistency?
What is the sid in oracle?
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
What do you understand by a database object?
Can objects of the same schema reside in different tablespace?
20. Using a set operator, display the client number of all clients who have never placed an order.
How to drop a stored procedure in oracle?
What are the common oracle dba tasks?
An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?
What are the different types of partitions in oracle?
What is an oracle wallet?
What is SQL Tuning Advisor in Oracle?
How to install oracle odbc drivers?
What are the logical operations?
