SELECT R,COUNT(R) FROM ( SELECT cityname,mail, CASE WHEN SUBSTR(MAIL,1,I

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

Question Posted / js

6 Answers
13049 Views
DELL, HCL, Oracle, I also Faced
E-Mail Answers

Answer Posted / js

SELECT R,COUNT(R) FROM
(
SELECT cityname,mail,
CASE WHEN SUBSTR(MAIL,1,INSTR(MAIL,'KM' )-1) BETWEEN 0 AND 50 THEN '0-50'
WHEN SUBSTR(MAIL,1,INSTR(MAIL,'KM' )-1) BETWEEN 51 AND 100 THEN '51-100'
ELSE '101-150' END R FROM CITY) GROUP BY R;

Is This Answer Correct ?

1 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Do ddl statements need commit?

927

Why are sql stored procedures used?

994

What does count (*) mean?

875

How do I partition a table in sql?

1046

What are tables and fields?

978

What is date functions?

964

What is pl sql package?

993

Define sql delete statement.

956

What are the parameter modes supported by pl/sql?

1024

What is a database trigger?

1022

How to look at the current sql*plus system settings?

1085

Is crud a cuss word?

978

What are the sql aggregate functions?

1068

What is the primary key?

880

Can I learn sql in a week?

1010