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

Why primary key is required?

985

---

explain advantages of myisam over innodb? : Sql dba

1054

---

What is sql deadlock?

1113

---

What packages are available to pl/sql developers?

1031

---

Is it possible to remove child records without removing master table records...the two having pk,fk relationship?

1246

---

What is delimiter sql?

966

---

What is the difference between stored procedure and view?

1008

---

What is rank () in sql?

926

---

What is difference between cursor and trigger?

1056

---

Write the command to remove all players named sachin from the players table.

1162

---

how to select unique records from a table? : Sql dba

1092

---

How do you explain an index?

1268

---

What is the difference between alter trigger and drop trigger statements?

1092

---

Advantages and disadvantages of stored procedure?

1103

---

What are the three pl sql block types?

988

---