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

Why self join is used in sql?

966

what are null values? : Sql dba

938

How do I upgrade sql?

990

is mysql query is case sensitive? : Sql dba

1077

Is foreign key mandatory?

991

What is the difference between numeric and autonumber?

983

Differentiate between sga and pga.

1146

Can I join the same table twice?

1035

What is server name sql?

1125

Explain the advantages and disadvantages of stored procedure?

1134

What action do you have to perform before retrieving data from the next result set of a stored procedure ?

2559

Explain the difference in execution of triggers and stored procedures?

1003

What is file based approach?

926

what is sub-query? : Transact sql

1086

What is difference between sql function and stored procedure?

991