What is difference between rank () row_number () and dense_rank () in sql?

0 Answers  

---

What is compute?

0 Answers  

---

What is audit logout in sql profiler?

0 Answers  

---

Explain the select statement in sql?

0 Answers  

---

How can I delete duplicate rows?

0 Answers  

---

explain access control lists. : Sql dba

0 Answers  

---

Why does sql need a server?

0 Answers  

---

Name the operator which is used in the query for pattern matching?

0 Answers  

---

How many sql core licenses do I need?

0 Answers  

---

In table a 1lakh data is present,in table b 20 thousand data is present, to get unique data from table a and b which join to be considered. whether right outer join or left inner join. 

2 Answers   GE,

---

What is pl sql commands?

0 Answers  

---

How many database objects (trigger, packages, sequence etc) uses a particular field in a given table. For ex: I want to know how many database object uses the ATTRIBUTE1 in the PO_VENDORS table. What query will give me the result showing the database object name(package, trigger etc), field_name used (in this case ATTRIBUTE1) and table_name (in this case PO_VENDORS).

2 Answers   IBM,

---