select range distance,count(range) no_of_city from (SELECT cityname,mails

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 / prativa mishra

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

Answer Posted / prativa mishra

select range distance,count(range) no_of_city
from
(SELECT cityname,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 CITY1)
group by range

Is This Answer Correct ?

20 Yes

2 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Does execute immediate commit?

1239

How is indexing done in search engines?

987

how to drop an existing index in mysql? : Sql dba

1079

How do I view a table in sql?

1015

What does pl sql stand for?

1125

What is gpt format?

952

Explain what is a view?

1070

Explain some predefined exceptions.

1047

where are cookies actually stored on the hard disk? : Sql dba

1044

Is pl sql still used?

987

What is file based approach?

950

Can you join views in sql?

970

What are its different types of dbms?

1022

How delete all records from table in sql?

986

What is the difference between subquery and correlated query?

1075