Answer in Horizontal out put select RANGE distance,count(range) no_of

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 / prasant kumar sahoo

6 Answers
8571 Views
I also Faced
E-Mail Answers

Answer Posted / prasant kumar sahoo

Answer in Horizontal out put
select RANGE distance,count(range) no_of_city
from
(SELECT citiname,mails,
CASE WHEN MAILS BETWEEN 0 AND 50 THEN '0-50'
WHEN MAILS BETWEEN 51 AND 100 THEN '51-100'
ELSE '101-150'
END RANGE
FROM test1)
group by range;

Is This Answer Correct ?

6 Yes

1 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How do sql triggers work?

1024

What is cartesian join in sql?

1100

How many types of relationship are there?

1021

What sql database should I use?

1125

What is t-sql? : Transact sql

970

how many sql ddl commands are supported by 'mysql'? : Sql dba

1005

How to return multiple rows from the stored procedure?

956

What is cursor in pl sql?

1101

What is data manipulation language?

1175

How many triggers can be applied to a table?

1045

Is pl sql useful?

971

How do I create a sql script?

1085

Can we insert delete data in view?

935

What are local and global Indexes and where they are useful.

1433

Define sql delete statement.

991