Answer Posted / niladri chatterjee

SQL> Select * From Market;

MARKET_ID MKT_NAME AREA SALE_DT
---------------------- -------- ---- ----------
1 uss NE 25-JAN-12
1 uss NE 24-FEB-12
1 uss NE 20-JUN-11
1 uss NE 15-MAR-11
2 rus SE 21-MAR-11
2 rus NE 24-APR-11
3 ger SE 20-FEB-11
3 ger NE 22-MAR-11
3 ger NE 24-FEB-12

My Answers:-

For the Single Max Row:

Select * From (Select * From market Order By Sale_Dt Desc)
Where rownum = 1;

Followings are for each Groups:

Select *
from market a
where a.sale_dt =
(select max(b.sale_dt) from market b
where a.market_id = b.market_id);

OR

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

What are ddl statements in oracle?

1127

---

What happens if the imported table already exists?

1077

---

How to convert character types to numeric types?

1193

---

What is index in Oracle?

1128

---

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

1091

---

How to execute a stored procedure in oracle?

1148

---

How to load a large xml file?

1105

---

Can we write dml statement in function in oracle?

1125

---

What language does oracle use?

1167

---

Can you have more than one content canvas view attached with a window ?

2370

---

Which is better Oracle or MS SQL? Why?

5031

---

Explain what are clusters?

1155

---

How to drop a tablespace?

1084

---

How to list all user accounts in oracle?

1066

---

what are bitmap indexes? How does they work?

2302

---