-- 1. create test table CreateTable # Order1 (OrderNamevarchar (50), RequestDatedatetime, OrderCountint) -- insert test data insertinto # Order1values (clothes, 2013-06-02,2) insertinto # Order1values (clothes, 2013-06-03,4) insertinto # Order1val
-- 1. create Table # Order1 (OrderName varchar (50), RequestDate datetime, OrderCount int) -- insert test data into # Order1 values ('clothes ', '2017-06-02 ', 2) insert into # Order1 values ('clothes ', '2017-06-03', 4) insert into # Order1 val
-- 1. Create a test table
Create Table # Order1
(
OrderName varchar (50 ),
RequestDate datetime,
OrderCount int
)
-- Insert Test Data
Insert into # Order1 values ('clothes ', '2017-06-02', 2)
Insert into # Order1 values ('clothes ', '2017-06-03', 4)
Insert into # Order1 values ('clothes ', '2017-06-04', 5)
Insert into # Order1 values ('shoes ', '2017-06-02', 3)
Insert into # Order1 values ('shoes ', '2017-06-03', 7)
Insert into # Order1 values ('shoes ', '2017-06-04', 8)
-- Select the latest one in each group
-- Method 1
Select * from
(
Select ROW_NUMBER () over (PARTITION By OrderName order by RequestDate DESC) as rownum, OrderCount, OrderName
From # Order1
) T
Where T. rownum = 1
-- Group by OrderName
Drop table # Order1
-- To be continued
, Hong Kong Space, website space, Hong Kong server rent