摘要： CREATE TABLE A( [购物人] NVARCHAR(10), [商品名称] NVARCHAR(10), [数量] INT) INSERT INTO ASELECT 'A','甲',2UNION ALL SELECT 'B','乙',4UNION ALL SELECT 'C','丙',1UNION ALL SELECT 'A','丁',2UNION ALL SELECT 'B','丙'... 阅读全文