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 truncate autocommit in oracle?

1090

---

What privilege is needed for a user to insert rows to tables in another schema?

1015

---

How do I connect to oracle database?

1125

---

hi friends i completed b.com 2004.i have 3y accounting exp. in manufacturing company.now i have completed oracle finance.pls suggest me how will get job in oracle.can i get job in oracle.

2370

---

How to use fetch statement in a loop?

1024

---

Explain what does a control file contain?

1105

---

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

1128

---

What do you mean by merge in oracle and how can we merge two tables?

1052

---

How to delete all rows a table in oracle?

1071

---

What are the different oracle database objects?

1096

---

What is the difference between substr and instr?

1042

---

What are the advantages of oracle?

1029

---

What is a subquery in oracle?

1114

---

Can a parameter be passed to a cursor?

1129

---

How to do a full database export?

1117

---