Loading

To count the columns values

sathish

6y948

Hi,

I need a sql query to count the values in the columns based on their items .

For example

And query to give output as

Thanks

Sathish

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Mageshwaran R6y ago
HI,
try this query:
SELECT COUNT(NAME1.SHOP1) AS SHOP1,count(NAME2.SHOP2) AS SHOP2,NAME1.SHOP1,NAME2.SHOP2 FROM TESTTABLE_NAME NAME1,TESTTABLE_NAME NAME2
WHERE NAME1.ID=NAME2.ID GROUP BY NAME1.SHOP1,NAME2.SHOP2

0
sathish6y ago
Can you plz provide with a simple example like my table
0
Priyanka Jain6y ago
Refer this forum post help to build your query

https://www.c-sharpcorner.com/forums/order-wise-item-produce-data-require-in-sql
0