Q) How to Find Max Date from each Group? (Asked in Infosys
(INFI)Interview)
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
How to write text literals in oracle?
What happens to indexes if you drop a table?
How to convert numbers to characters in oracle?
How many anonymous blocks can be defined?
Explain the use of rows option in exp command.
What is integrity and what is constraint??Explain with example
what is difference between sql plus and sql*plus? (not sql and sql plus).
How to estimate disk space needed for an export job?
What are the uses of Database Trigger ?
how to handle exceptions in post production
Which is better Oracle or MS SQL? Why?
How do we represent comments in oracle?
What is oracle join syntax?
How to write a left outer join with the where clause in oracle?
Why is oracle so popular?