How to give a count of a column in SQL:

Example: Give the count of ice creams by their selling status.

Select selling_status, count(Ice_cream_flavor) FROM ICECREAM group by selling_status;

Output:

SQL> Select selling_status, count(Ice_cream_flavor) FROM ICECREAM group by selling_status;

SELLING_STATUS COUNT(ICE_CREAM_FLAVOR)

————– ———————–

low                                  3

medium                               4

Null                                 4

high                                 4

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s

%d bloggers like this: