Answer Posted / prasant kumar sahoo

Here I am giving the query in SQL in Vertical Out put
----------------------------------------------
select * from (select (select count(*) from (select
count(citino) from test1 where mails between 0 and 50 group
by citino) t1) as "0-50",
(select count(*) from (select count(citino) from test1 where
mails between 51 and 100 group by citino) t2) as "51-100",
(select count(*) from (select count(citino) from test1 where
mails between 101 and 150 group by citino) t3) as "101-150"
from test1) "Result" where rownum=1;
---------------------------------------------------
if u want to Horizontal out put it need an another table
that store the range like 0-50,51-100 like. And then U just
Join this it so easy. If you need then, mail me
---------------------------------------------
if you need in Plsql also mail me I will send you

what are string data types? : Sql dba

1050

---

what is the syntax used for partition in tsql? : Transact sql

1025

---

Does sql view stored data?

963

---

When a dml statement is executed, in which cursor attributes, the outcome of the statement is saved?

1124

---

What are inbuilt functions in sql?

1071

---

How to disable a trigger name update_salary?

1274

---

what are wild cards used in database for pattern matching ? : Sql dba

1150

---

Is t sql a programming language?

1073

---

What is the file extension for sql database?

1012

---

What is java sql connection?

1068

---

Why do we use sql constraints? Which constraints we can use while creating database in sql?

1048

---

What is mdb stand for?

1016

---

What are the different types of dbms?

1020

---

Define commit, rollback and savepoint?

1038

---

How consistent is the view of the data between and within multiple sessions, transactions or statements ?

2229

---