select market_id, mkt_name, max(sale_dt) from market group by market

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

Question Posted / sudipta santra

Answer Posted / sudipta santra

select market_id, mkt_name, max(sale_dt)
from market
group by market_id, mkt_name;

Note: This is the only correct answer

Is This Answer Correct ?

5 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is tns service name?

1122

Explain an index?

1130

What operating systems are supported by oracle database 10g xe?

1032

How do we get field details of a table?

978

Will you be able to store pictures in the database?

1116

What are the predefined tablespaces in a database?

1079

What is oracle database client?

1030

How would you begin to troubleshoot an ORA-3113 error?

2077

How to create a stored function in oracle?

1105

Does oracle database need java?

1002

What is index in Oracle?

1070

Give the advantages and disadvantages of clusters.

1050

What is transaction control statement and how many types of transaction control statement in Oracle?

1152

What are the set operators union, union all, minus & intersect meant to do?

987

Explain the use of indexes option in exp command.

1142