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
13282 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 java sql driver?

1124

Can we use loop in sql?

969

What are reports usually used for?

1023

What are conditional predicates?

1061

Which operator is used in query for pattern matching?

1089

What is the example of procedure?

928

How to avoid duplicate records in a query?

1008

How do I run sql profiler?

1072

What are the two virtual tables available at the time of database trigger execution?

1222

What is the difference between the conventional and direct path loader? : aql loader

1153

What is record in pl sql?

1083

Under what condition it is possible to have a page level lock and row lock at the same time for a query? : Transact sql

990

What is sqlca in db2?

970

Why do we use set serveroutput on?

965

How do I truncate a sql log file?

1074