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
- 8424 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 columnar storage what is the advantage?
How will you differentiate between varchar & varchar2?
What is an oracle and why it is used?
Is it possible to set second Primary Key Constraint in a table in Oracle Database ?
What is a user role in oracle?
What is a data lock in oracle?
How data locks are respected in oracle?
What is open database communication (odbc) in oracle?
Explain table?
please explain.. DB architecture ...
How can we force the database to use the user specified rollback segment?
What are the common oracle dba tasks?
What are set operators?
What is the sql query to concatenate column values from multiple rows in oracle?
How many types of cluster table in Oracle?
