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
- 6 Answers
- 6921 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
Can we use ddl statements in stored procedure?
What is replication id?
what is query cache in mysql? : Sql dba
Which are the different character-manipulation functions in sql?
What is sql rowcount?
What is sql exception?
How to use distinct and count in sql query? Explain
What version is sql?
How many tables can you join in sql?
Does sql*plus also have a pl/sql engine?
What are the conditions an underlying table must satisfy before a cursor can be used by a positioned update or delete statement? : Transact sql
What are the types of index in sql?
What are the commands used in sql?
what is a table in a database ? : Sql dba
List different type of expressions with the example.
