Home » SQL & PL/SQL » SQL & PL/SQL » Total Count
Total Count [message #8785] Thu, 25 September 2003 10:44
Dan
Messages: 61
Registered: February 2000
Member
How do I add a total count of rows after running this query? I can not seem to get count(distinct g.grp_id) to work.

Thanks!

select
g.grp_id,
g.parent_grp_id,
g.grp_type_id,
g2.grp_type_id,
g2.name
from user_admin.grp g, user_admin.grp g2
where g.grp_type_id = 4
and g.parent_grp_id = g2.grp_id
and g2.grp_type_id = 3
and g2.parent_grp_id <> 33

Report message to a moderator

Previous Topic: Analizing table
Next Topic: Using IF-THEN-ELSE in an UPDATE Statement
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Apr 23 16:25:16 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.