1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

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

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 an index? : Sql dba

510

How to Declare Fixed Length String Value In PL SQL

652

How do temporal tables work?

510

What is a schema? How is it useful in sql servers?

578

What are different types of sql commands?

498




What are the types of variables use in pl sql?

490

Does sql support programming?

541

What is self-join and what is the requirement of self-join?

617

What does seeding a database mean?

517

What operators deal with null?

593

What is the difference between left outer join and left join?

499

What is crud sql?

532

how to convert numeric values to character strings? : Sql dba

558

What is join view in sql?

501

How do I run sql?

602