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
- 8563 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 are the differences between char and varchar2 in oracle?
How to drop an index in oracle?
Why do I get unexpected characters from 8-bit character sets in weblogic jdriver for oracle?
What is varray?
How to sort the query output in oracle?
How to run queries on external tables?
When do I need to use a semicolon vs a slash in oracle sql?
Describe an oracle table?
I creat Credit memo in AR. Now i want revers the Credit Memo.how you can revers that what out any aditional entry.
What is a cursor in oracle?
What is meant by raw datatype?
How does the on-delete-cascade statement work?
What is an oracle?
What is a select query statement in oracle?
Can we connect to ORACLE db using Windows Authentication?
