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 declare a local variable?

1176

---

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

1076

---

How to connect to a remote server?

1192

---

How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?

1970

---

What is rich query?

1037

---

Does facebook use oracle?

1085

---

How many types of table in Oracle?

1173

---

What is a trigger oracle?

1140

---

How to drop an index?

1015

---

What is the sid in oracle?

1033

---

What are the built-in functions used for sending Parameters to forms ?

3437

---

What is the usage of synonyms?

1219

---

What is a nested table and how is it different from a normal table?

1112

---

What types of joins are used in writing subqueries?

1033

---

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

1236

---