How show all rows in sql?

0 Answers  

---

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 pls give me answer. i want urgent

6 Answers  

---

What does a pl/sql package consist of?

0 Answers  

---

Hi all, i have a table as follows empid empname mgrid deptid 1 a 3 4 2 b 1 5 3 c 2 3 4 d 3 6 5 e 4 7 i want the output as empname mgrname a c b a c b d c e d

4 Answers  

---

I want to execute a piece of code before calling a procedure. How to achieve it?

1 Answers   Oracle,

---

---

How can you know that statistics should be updated?

0 Answers  

---

How do I start sql from command line?

0 Answers  

---

What is difference between cursor and ref cursor?

1 Answers  

---

What is the difference between python and sql?

0 Answers  

---

What are sql injection vulnerabilities?

0 Answers  

---

how to get enames with comma seperated values by deptwise on emp table?

8 Answers  

---

Explain the the update statement in sql?

0 Answers  

---