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

Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?

3624

Which sql statement is used to delete data from a database?

1012

What is sql indexing?

1065

Does pdo prevent sql injection?

990

What is the meaning of disabling a trigger?

1243

What is rowtype?

1081

Explain constraints in sql?

1088

Is postgresql a server?

1114

What is using in sql?

1143

what is a materialized view? : Sql dba

1133

What is sql constant?

1104

what does myisamchk do? : Sql dba

1079

What are sql functions? Describe in brief different types of sql functions?

1187

What is the process of copying data from table a to table b?

1141

How many types of triggers exist in pl/sql?

1139