select market_id, mkt_name, sale_dt from ( select market_id, mkt

Q) How to Find Max Date from each Group? (Asked in Infosys
(INFI)Interview)

Question Posted / suman rana

4 Answers
8318 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

Please Help Members By Posting Answers For Below Questions

Can a parameter be passed to a cursor?

1082

How a database is related to tablespaces?

1003

what is a Nested Loop join?

2057

Explain the use of indexes option in exp command.

1092

How to create a new view in oracle?

1033

How do you increase the OS limitation for open files (LINUX and/or Solaris)?

1897

How to call a stored function in oracle?

975

How to grant create session privilege to a user in oracle?

964

WHAT IS THE DEFINITION OF DEFAULT CUSTOMER IN AR?

2181

What is merge in oracle?

1010

What privilege is needed for a user to create indexes in oracle?

984

How many types of table in Oracle?

1083

What is oracle data type?

919

How to rebuild an index in oracle?

990

Can a formula column referred to columns in higher group ?

2476