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 does data normalization mean?

1028

---

What is compute?

1155

---

List and explain the different types of join clauses supported in ansi-standard sql?

1409

---

how to convert dates to character strings? : Sql dba

1255

---

What is dml and ddl?

1013

---

What are data types in pl sql?

1200

---

What is the use of stored procedures?

1113

---

Is a foreign key always unique?

984

---

What are primary key and foreign key and how they work?

1022

---

What is a clob in sql?

1066

---

what is denormalization. : Sql dba

1167

---

What do you mean by table in sql?

1045

---

What is bulk collect in pl sql?

1160

---

What is trigger in sql and its types?

1113

---

What are the types of keys?

1067

---