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

When are we going to use truncate and delete?

925

---

What is an alias command?

1002

---

Why do we need pl sql?

934

---

Does sql full backup truncate logs?

965

---

What is dialect in sql?

887

---

What is sql basics?

990

---

what is index? : Sql dba

942

---

What is rename in sql?

915

---

Is a foreign key always unique?

882

---

How does one load ebcdic data? : aql loader

1092

---

What is a system versioned table?

927

---

Which is faster union or join?

901

---

Show the cursor attributes of pl/sql.

995

---

how to enter binary numbers in sql statements? : Sql dba

921

---

Can we perform dml in function?

1013

---