Hi, I need a sql query to count the values in the columns based on their items . For example Col A Col B Shop 1 Table Shop 1 Table Shop 2 Chair Shop 1 Chair Shop 2 Table Shop 1 Chair Shop 2 Table Shop 2 Chair And query to give output as Name Table Chair Shop 1 2 2 Shop 2 2 2 Thanks Sathish

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

Can you plz provide with a simple example like my table

Refer this forum post help to build your query https://www.c-sharpcorner.com/forums/order-wise-item-produce-data-require-in-sql

Answers

To count the columns values

sathish

804

1 SQL Server

Hi,

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

For example

Col A	Col B
Shop 1	Table
Shop 1	Table
Shop 2	Chair
Shop 1	Chair
Shop 2	Table
Shop 1	Chair
Shop 2	Table
Shop 2	Chair

And query to give output as

Name	Table	Chair
Shop 1	2	2
Shop 2	2	2

Thanks

Sathish

To count the columns values

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (3)