Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to Count Records and Populate Value in Results

Johnbr (Oracle10G)Dec 9 2011 — edited Dec 9 2011
Hi Everyone,

I'm a newb in SQL so my questions will be pretty basic for a while.

I have a statement that returns results like this.
gs_assembly_guid	     gs_assembly_quantity	
E2.1		     1
E2.1		     1
However, what I really need is a result set that counts E2.1 and provides the count as a quantity within 1 E2.1 Result like this:
gs_assembly_guid	     gs_assembly_quantity	
E2.1		     2	
Thanks for steering me in the right direction.

:) John

Edited by: Johnbr (Oracle11G) on Dec 9, 2011 9:47 AM
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 6 2012
Added on Dec 9 2011
8 comments
311 views