Answer Posted / prasant kumar sahoo

Answer in Horizontal out put
select RANGE distance,count(range) no_of_city
from
(SELECT citiname,mails,
CASE WHEN MAILS BETWEEN 0 AND 50 THEN '0-50'
WHEN MAILS BETWEEN 51 AND 100 THEN '51-100'
ELSE '101-150'
END RANGE
FROM test1)
group by range;

What is normalization? How many normalization forms are there?

1009

---

Can you do multiple joins in sql?

969

---

What is cursor and why it is required?

1105

---

what does it mean to have quoted_identifier on? What are the implications of having it off? : Sql dba

944

---

How many sql statements are used?

960

---

How do I view output in sql developer?

1026

---

what is the difference between ereg_replace() and eregi_replace()? : Sql dba

1071

---

How do I run pl sql in sql developer?

1058

---

Are null values same as that of zero or a blank space?

966

---

what is a stored procedure? : Sql dba

1051

---

What is embedded sql in db2?

955

---

What is sqlite format?

1107

---

what is sql in mysql? : Sql dba

1120

---

how can you see all indexes defined for a table? : Sql dba

933

---

How do I write a cron which will run a sql query and mail the results to agroup?

910

---