亚洲乱色熟女一区二区三区丝袜,天堂√中文最新版在线,亚洲精品乱码久久久久久蜜桃图片,香蕉久久久久久av成人,欧美丰满熟妇bbb久久久

(
    [rowid] [int] primary key IDENTITY(1,1) NOT NULL,
    [name] [nchar](10) NULL,
    [price] [int] NULL
)
insert INTO Products VALUES('蘋(píng)果',    50);
insert INTO Products VALUES('橘子',    100);
insert INTO Products VALUES('橘子',    100);
insert INTO Products VALUES('橘子',    100);
insert INTO Products VALUES('香蕉',    80);
insert INTO Products VALUES('香蕉',    80);

where p1.rowid<
(
    select MAX(p2.rowid) from products p2 
    where p1.name=p2.name and p1.price=p2.price
)
--結(jié)果：
--    rowid        name    price
--      1            蘋(píng)果        50
--      4            橘子        100
--      6            香蕉        80