sum of two count( columns)

[kandhi17]

could any one kindly help me for writing a query for

sum of two columns with count from same table.

ex: quantity1, quantity2
sum(count(quantity1), count(quantity2))

 

[rac2]

sum of two columns with count from same table"

????????

You may simply add the two counts in an expression.

SELECT widget_name, SUM(qty_delivered) + SUM(qty_backordered)
FROM WidgetOrders
GROUP BY widget_name

This would give for each widget the number delivered plus the number on backorder. Presumably that would be the number ordered.


Possibly you wish to count the number of orders for a widget.

SELECT widget_name, SUM(qty_delivered) + SUM(qty_backordered), COUNT(*)
FROM WidgetOrders
GROUP BY widget_name

Possibly you wish to count the number of orders with deliveries and the the number of orders with backorders.
Assuming the value of qty_backordered is zero if nothing is backordered and the value of qty_delivered is zero if nothing is delivered.

SELECT widget_name, 
       SUM(qty_delivered) + SUM(qty_backordered), 
       COUNT(*), 
       SUM(CASE
             WHEN qty_delivered = 0 THEN 0
             ELSE 1
           END),
       SUM(CASE
             WHEN qty_backordered = 0 THEN 0
             ELSE 1
           END)
FROM WidgetOrders
GROUP BY widget_name

 

[kandhi17]

thanks for replying, but i would like to count the column1 and column2 individually and then sum of column1, column2.

i will appreciate if you could reply me back again

 

[rac2]

What do you mean by counting column1?

In general we count rows. Either all of the rows with COUNT(*) or the rows which are not NULL with COUNT(column_name).

 

[rac2]

If you wish to have the separate counts of NOT NULL rows then list each one in the SELECT list.

SELECT COUNT(colA), COUNT(colB), COUNT(colA) + COUNT(colB)
...