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

Is pl sql and postgresql same?

1183

What view means?

1026

How many clustered indexes can you have?

1039

What are sql functions? Describe the different types of sql functions?

1216

How do you drop a trigger?

1037

Is nosql relational?

1002

what is a relationship and what are they? : Sql dba

1166

What are system versioned tables?

1075

Can we perform dml in function?

1135

what is online transaction processing (oltp)? : Sql dba

1041

What does count (*) mean in sql?

1657

Explain about various levels of constraint.

1000

What is rownum?

1034

What are different types of indexes?

1058

What program will open a mdb file?

1020