create table xyz ( x varchar2(30),y varchar2(30),z number); insert into

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

pls give me answer. i want urgent

Question Posted / anjan ghosh

6 Answers
8649 Views
I also Faced
E-Mail Answers

Answer Posted / anjan ghosh

create table xyz ( x varchar2(30),y varchar2(30),z number);

insert into xyz values (6 , 'HEBBAL' ,115);

select count(*) as No_of_city , '0-50' as Distance from xyz
where z between 0 and 50
union all
select count(*)as No_of_city ,'51-100' as Distance from
xyz where z between 51 and 100
union all
select count(*)as No_of_city ,'101-150' as Distance from
xyz where z between 51 and 100

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is the difference between an inner join and an outer join?

1033

Can we use ddl commands in pl sql?

1171

How can I change database name in sql?

1091

What are stored procedures in mysql?

1025

Why do we need cursors in pl sql?

1093

How is use pl and sql?

1071

What is pl sql script?

1036

Why do we use view in sql?

975

What is the main difference between sql and pl/sql?

1105

Are pl sql variables case sensitive?

1053

What are joins in sql?

1050

What is data abstraction in sql?

1036

How to disable a trigger name update_salary?

1273

What is sql deadlock?

1151

Is hadoop a nosql?

1011