pls send me pl/sql script also

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 / ram

6 Answers
8629 Views
I also Faced
E-Mail Answers

Answer Posted / ram

pls send me pl/sql script also

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 compound trigger?

1034

describe transaction-safe table types in mysql : sql dba

1006

What are the datatypes available in pl/sql ?

1103

What is %rowtype in pl sql?

989

What port does sql server use?

1060

Why use stored procedures?

1090

What are the types of variable use in pl sql?

1080

What are the qualities of 2nf?

1039

Why do we use triggers?

967

What is the difference between sum and count in sql?

986

How delete a row in sql?

992

What are synonyms in sql?

971

What does pl sql developer do?

924

Define join and name different types of joins?

1008

What is difference between left and right outer join?

985