Counting of Rows with the same string occurrencies

[estersita]

Hi!

I am trying to count occurrences (rows) which contain equal strings break on the same fileld

In other words I need counting subtotal and total but I do not need computation as these are just strings

For example I have:

Code

Zp
Zp
Zp
Zp
No
No
No
Yes
Yes

What I need is:

Zp
---------------
Subtotal =4

No
__________
Subtotal=3
Yes
__________
Subtotal=2

Could you please help me with it?

Thank you in advance!

Estersita

 

[carp]

SELECT code, count(*)
FROM my_table
GROUP BY code;

 

[estersita]

Carp,

Thank you for your quick response. I wonder however if it would be correct if I chose to include other filelds in the output.

For ex:

SELECT anotherFld,code, count(*)
FROM my_table
GROUP BY code;

Should I include them into GROUP BY clause?
OR
If I do not...then would it be correct?

Thank you !

Estersita

 

[carp]

SELECT anotherFld,code, count(*) 
FROM my_table
GROUP BY code;

won't work since you need to GROUP BY every non-grouping item in your SELECT list. Consequently, you would need to use

SELECT anotherFld, code, count(*) 
FROM my_table
GROUP BY anotherFld, code;

which may not be what you want.

Please post your full situation so that we can respond to the real problem rather than providing iterative answers that eventually get you to where you want to go. Are you running this via sql*plus, or another reporting tool? How many different fields are you really including? What other types of values are you looking for? The more information you provide in your initial post, the faster you are likely to get a solution that's suitable for your problem.