OraFAQ Forum: SQL & PL/SQL » It is possible?

Home » SQL & PL/SQL » SQL & PL/SQL » It is possible?

Wed, 30 May 2007 08:20

dspegas
Messages: 1
Registered: May 2007
Location: Brasil

Junior Member

Select avg(count(*)) from books
group by book_id

????

Wed, 30 May 2007 08:33

kdipankar
Messages: 9
Registered: December 2006

Junior Member

Try out this

   select avg(x.cnt) from (select count(1) cnt from books group by book_id) x

Wed, 30 May 2007 08:35

mbalves
Messages: 20
Registered: May 2007

Junior Member

..or try out this

Select avg(c1) from (select book_id, count(*) c1 from books group by book_id)

Wed, 30 May 2007 08:42

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Yes this is possible.

SQL> select avg(count(*)) from emp group by deptno;
AVG(COUNT(*))
-------------
   4.66666667

1 row selected.

Regards
Michel

Previous Topic:	Trigger problem
Next Topic:	table design question: storing both character data and numeric data in a VARCHAR2(10)

Goto Forum:

]

Current Time: Wed Dec 04 18:55:42 CST 2024