샐님은 개발중

select result.* from ( SELECT *, RANK() OVER(PARTITION BY fACTORYCODE, ItemCode ORDER BY updatedate desc) AS RANK_NO FROM OutSourcingPrice )as result where rank_no = 1 * RANK() : '순위 함수' 로 OVER 절과 함께 사용해야 하며 OVER 절 내부의 ORCER BY 절에 순위 칼럼을 지 1) PARTITION BY : 그룹을 지을 컬럼 2) ORDER BY : 상세한 순위 조건

USE [M-DB] GO /****** Object: StoredProcedure [dbo].[CreateProductResult] Script Date: 2023-06-25 오후 11:16:48 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO -- 1. bom 소요량 만큼 productresult_mst, productresult_dtl 데이터 생성 -- 2. 소요량 만큼 재고에서 차감 ALTER PROCEDURE [dbo].[CreateProductResult] ( @ParentProductId int -- 만들려는 제품 id ) AS declare @Index as int, @ProductID as int, @Qty as int, @tQty as..

-- convert tows into columns select [1],[2],[3],[4],[5],[6],[7],[8],[9],[10],[11],[12],customer from (select year(orderdate) as [year], month(orderdate) as [month], isnull(customerid,0) as customer ,sum(subtotal)as sales from sales where year(orderdate) = '2020' group by grouping sets ((year(orderdate)), (year(orderdate),month(orderdate)), (year(orderdate),month(orderdate),customerid)) ) as Sour..

select * from sales -- 년별 합계 select year(Orderdate), sum(subtotal) from sales group by year(orderdate) -- 월별 합계 select year(Orderdate),month(orderdate), sum(subtotal) from sales group by year(orderdate),month(orderdate) -- 년/월 함께 select year(orderdate), month(orderdate), sum(subtotal) as sales from sales where year(orderdate) = '2020' group by grouping sets ((year(orderdate)), (year(orderdate),m..