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

pls give me answer. i want urgent

Question Posted / ram

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

when is the use of update_statistics command? : Sql dba

504

Define commit, rollback and savepoint?

581

What are inbuilt functions in sql?

604

What is primary key in db?

523

What is clustered and nonclustered index in sql?

504




What is the maximum database size for sql express?

540

What is a unique key?

589

What are the basic techniques of indexing?

577

How many subqueries can be nested in a statement?

510

Whis is not false in primary key?

978

What is the purpose of a secondary key?

513

what is the stuff function and how does it differ from the replace function? : Sql dba

624

What is procedure explain with program?

554

What is set transaction?

586

What are the different types of tables in sql?

487