How many rows will return from dual table?

4 Answers   Fujitsu,

---

I Have A Table Like This. Cityno Cityname Mails 1 Bangalore 8km 2 Hsr Layout 20km 3 Mejistic 30km 4 Jayadeva 55km 5 Itpl 80km 6 Hebbal 115km I Have Data Like This I Want O/p Like This Distance No.ofcity 0-50km 3 51-100km 2 101-150km 4 And So On

6 Answers   DELL, HCL, Oracle,

---

What are the types of subqueries?

0 Answers  

---

What is difference between sql and mysql?

0 Answers  

---

what are the differences among these table level lock modes - IN SHARE MODE, IN SHARE UPDATE MODE, IN EXCLUSIVE MODE ?

3 Answers   HCL,

---

What sql does db2 use?

0 Answers  

---

What is PL/SQL Records?

0 Answers  

---

what is the difference between primary key and unique key? : Sql dba

0 Answers  

---

.  have a tablle like this: cust acc ----------- a 1 b 2 b 3 c 4 c 5 c 6 I Want below o/p: cust acc --------------- a 1 b 2|3 c 4|5|6 Please any one can you have any ideas share me. I have urgent requirement. CUST         ACC a            dv b            fg b            bh c            mk c            cl c            so result:- A  B   c dv fg mk    bh cl       so

3 Answers  

---

With out using count() function. How to the find total number of rows in a table?

6 Answers  

---

what is sql optimization

1 Answers   Fidelity,

---

Is mariadb a nosql database?

0 Answers  

---