'Sql - use (Group by) with 2 columns

I have table named (TB1) with columns (Device - Order_id - qty) .... enter image description here

I want write sql query to show each (order No) with (device name) with (total device qty) in this order ... I know we must use (group by) ... But I don't know how do that

sqlgroup-by


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions