Answer Posted / kavitha nedigunta

SELECT DISTANCE,COUNT(*) NO_OFCITY
from
(SELECT (CASE WHEN TO_NUMBER(RTRIM(MAILS,'KM')) BETWEEN 0
AND 50 THEN '0-50'
WHEN TO_NUMBER(RTRIM(MAILS,'KM')) BETWEEN 51 AND
100 THEN '51-100'
ELSE '101-150' END) DISTANCE
FROM TEST001) A
GROUP BY DISTANCE
order by to_number(replace(DISTANCE,'-',''))

How do I find duplicates in sql?

939

---

How do I partition a table in sql?

1141

---

What type of database is cloud sql?

1110

---

Why do we need cursors in pl sql?

1093

---

Do ddl statements need commit?

978

---

What do you mean by rowid?

986

---

Any attempt to navigate programmatically to disabled form in a call_form stack is allowed?

1109

---

What has stored procedures in sql and how we can use it?

1087

---

Write the alter statement to enable all the triggers on the t.students table.

1131

---

The select into statement is most often used to create backup copies of tables or for archiving records?

1072

---

What is the use of primary key?

1012

---

What is partition by in sql?

1077

---

What is the use of index in hive?

1007

---

Is sql better than access?

1023

---

what is data control language? : Sql dba

1033

---