what are the differences among rownum, rank and dense_rank? : Sql dba

0 Answers  

---

what is the difference between a web-garden and a web-farm? : Sql dba

0 Answers  

---

Is mariadb nosql?

0 Answers  

---

i want count no of values in a column i.e enam eempno phoneno x 1 (98765,09887,096561,87964579,156678,678900876) that means if i select phone no from table i want to get total count of phone numbers i.e 6

8 Answers   Satyam,

---

Are views faster than queries?

0 Answers  

---

---

Can 2 queries be executed simultaneously in a distributed database system?

0 Answers  

---

How to get list of all tables from a database?

0 Answers  

---

What is the benefit of foreign key?

0 Answers  

---

source destination distance chennai bangalore 500 bangalore chennai 500 hyd delhi 1000 delhi hyd 1000 bangalore hyd 800 Here chennai to bangalore and bangalore to chennai is same distance. and hyd and delhi also same criteria. Based on the distance i want to display only one row using sql query?

4 Answers   JPMorgan Chase,

---

What is a cursor for loop ?

4 Answers  

---

What is the diffrence between IN and EXISTS.which one is faster.

3 Answers   Infogain,

---

When you have to use a default "rollback to" savepoint of plvlog?

0 Answers  

---