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
8430 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 are the different type of sql's statements ? : Sql dba

874

What is sql*loader?

1078

What is #table in sql?

1001

How do I view an execution plan in sql?

924

What is a full join sql?

983

What is difference between table and view?

980

What are the advantages of sql?

1008

What is where clause in sql?

984

Is sql free?

889

Is keyword pl sql?

933

what is a record in a database ? : Sql dba

999

how to present a past time in hours, minutes and seconds? : Sql dba

946

What are reports usually used for?

971

Which software is used for pl sql programming?

932

what is myisam? : Sql dba

1001