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
13504 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

What are the advantages of sql?

1100

What are sql triggers used for?

1035

what is primary key? : Sql dba

1083

What if we write return in procedure?

1514

How do I create an index in word?

1076

What are sql built in functions?

981

What is duration in sql profiler trace?

1140

How can you fetch first 5 characters of the string?

1068

What does pl sql stand for?

1156

What is a primary key sql?

1093

What are the two characteristics of a primary key?

1033

Is delete faster than truncate?

1052

How do I debug a stored procedure?

1171

What are tables and fields in the database?

1191

what are the disadvantages of mysql? : Sql dba

1209