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

How to concatenate two text values in oracle?

1118

---

definition of cluster and non-clustered index?

3036

---

How would you best determine why your MVIEW couldnt FAST REFRESH?

1897

---

What is merge in oracle?

1062

---

How to find the duplicate rows count from employees table in oracle?

1102

---

How many categories of data types?

1003

---

How to open and close an explicit cursor in oracle?

1063

---

How to use regular expression in pattern match conditions in oracle?

1046

---

Briefly explain what is literal? Give an example where it can be used?

1049

---

is there a tool to trace queries, like profiler for sql server?

1148

---

How to use like conditions in oracle?

1070

---

 How to use an oracle sequence generator in a mapping?

1080

---

What is oracle used for?

1031

---

Who developed oracle & when?

1013

---

What is a sub query and what are the different types of subqueries?

1133

---