22,209
社区成员
发帖
与我相关
我的任务
分享
--go
--CREATE TABLE test_fruit
--(
-- id INT,
-- [name] NVARCHAR(22),
-- [price] DECIMAL(18,2)
--)
--INSERT INTO test_fruit
--SELECT 1 AS 'id' ,'苹果' AS 'name',1250 AS 'price' UNION ALL
--SELECT 1 AS 'id' ,'香蕉' AS 'name',1326 AS 'price' UNION ALL
--SELECT 1 AS 'id' ,'西瓜' AS 'name',236 AS 'price' UNION ALL
--SELECT 1 AS 'id' ,'西红柿' AS 'name',2365 AS 'price' UNION ALL
--SELECT 1 AS 'id' ,'草莓' AS 'name',3695 AS 'price' UNION ALL
--SELECT 2 AS 'id' ,'苹果' AS 'name',2250 AS 'price' UNION ALL
--SELECT 2 AS 'id' ,'香蕉' AS 'name',2326 AS 'price' UNION ALL
--SELECT 2 AS 'id' ,'西瓜' AS 'name',1364 AS 'price' UNION ALL
--SELECT 2 AS 'id' ,'西红柿' AS 'name',1365 AS 'price' UNION ALL
--SELECT 2 AS 'id' ,'草莓' AS 'name',2695
GO
SELECT *
FROM test_fruit a
WHERE name IN ( SELECT TOP 3
name
FROM test_fruit
WHERE id = a.id
ORDER BY id )
id name price
----------- ---------------------- ---------------------------------------
1 苹果 1250.00
1 香蕉 1326.00
1 西瓜 236.00
2 苹果 2250.00
2 香蕉 2326.00
2 西瓜 1364.00
(6 行受影响)