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

Mention what are different methods to trace the pl/sql code?

1208

---

What makes a good primary key?

1043

---

what is blob? : Sql dba

1149

---

How to make a copy values from one column to another in sql?

1037

---

Is sql open source?

979

---

what are the t string functions available in tsql? : Transact sql

1009

---

what are the differences between require and include, include_once and require_once? : Sql dba

1023

---

how to get a list of all tables in a database? : Sql dba

977

---

What are the various levels of constraints?

1125

---

What is trigger types of trigger?

1070

---

What is sql trigger example?

1067

---

Can we use ddl statements in stored procedure sql server?

1012

---

What is record type in pl sql?

995

---

how would you enter characters as hex numbers? : Sql dba

985

---

What is nosql example?

1035

---