SQL分组聚合查询练习(SQL Server和Oracle相似)20190514

CREATE TABLE [dbo].[orderdt_jimmy](
    [nid] [int] PRIMARY KEY IDENTITY(1,1) NOT NULL,
    [order_nid] [int] NOT NULL,
    [sku] [varchar](100) NOT NULL,
    [qty] [int] NOT NULL,
    [price] [decimal](12, 2) NULL,
    [amount] [decimal](12, 2) NULL
);
GO

select t1.rn,t1.order_nid,t1.sku,t1.qty,t1.price,t1.amount from(
select *,ROW_NUMBER() over(partition by order_nid order by sku) rn from orderdt_jimmy) t1
where t1.rn < 5
order by nid,rn;
go