목록union (2)

RE:cord

[SQL] Why UNION?

-----If not using union...SELECT ProductID, SUM(OrderQty) AS TotalQty, COUNT(OrderQty) NoOfSales, CASE WHEN AVG(OrderQty) 6 THEN 'High quantity' END AS AvgQtyDescribeFROM Sales.SalesOrderDetail AS SOD JOIN Sales.SalesOrderHeader AS SOH ON SOD.SalesOrderID = SOH.SalesOrderIDWHERE SOH.OrderDate BETWEEN '2012-05-01' AND '2012-05-31'GROUP BY SOD.ProductIDORDER BY AVG(OrderQty) DESC -----If using..
SQL 2024. 12. 14. 19:42
[SQL] UNION / COUNT / BETWEEN

SELECT games FROM olympics_athletes_events WHERE age = (SELECT max(age) FROM olympics_athletes_events) UNION SELECT games FROM olympics_athletes_events WHERE age = (SELECT min(age) FROM olympics_athletes_events);   select count(order_id) from shopify_orders;   SELECT worker_id, login_timestamp FROM worker_loginsWHERE login_timestamp BETWEEN '2021-12-13 00:00:00' AND '2021-12-19 23:59:59'; Just i..
SQL 2024. 11. 22. 13:42
이전 Prev 1 Next 다음