sql 查询每个gcid的前3个[解决办法]SELECT * FROM Ta AWHERE EXISTS(SELECT 1FROM (SELECT gidMIN(GID)+3
sql 查询每个gcid的前3个
[解决办法]
SELECT *
FROM Ta A
WHERE EXISTS
(SELECT 1
FROM
(SELECT gid=MIN(GID)+3,gcid
FROM Ta Group By gcid
) B
WHERE A.gcid=b.gcid And A.gid<b.gid
)