select '0-50' distance, count(*) No.ofcity from table where mail

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 / janani

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

Answer Posted / janani

select '0-50' distance, count(*) No.ofcity from table
where mails between 0 and 50
union
select '51-100' distance, count(*) No.ofcity from table
where mails between 51 and 100
union
select '101-150' distance, count(*) No.ofcity from table
where mails between 101 and 150

Is This Answer Correct ?

5 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is sql comments?

1038

What is the max nvarchar size?

899

What is an alias command?

1007

What are the different schemas objects that can be created using pl/sql?

969

What are the basic techniques of indexing?

1015

What are user defined functions?

951

Write a program that shows the usage of while loop to calculate the average of user entered numbers and entry of more numbers are stopped by entering number 0?

2230

What is the difference between subquery and correlated query?

991

How do you update sql?

917

What packages(if any) has oracle provided for use by developers?

5720

Is delete faster than truncate?

962

What is faster join or subquery?

962

How to get help at the sql prompt?

1057

what is the difference between mysql_fetch_object and mysql_fetch_array? : Sql dba

990

What are the different types of dbms?

958