查询以获取每个EmpGroup的任何2个EmpCode

试试这个查询

SET @level = 0;SET @group = '';SELECt EmpCode,EGroupFROM (    SELECt         City,        EmpCode,        EmpGroup,        @level := IF(@group = EmpGroup, @level+1, 1) AS level,         @group := EmpGroup as EGroup     FROM test    ORDER BY EmpGroup ) rsWHERe level < 3

输出

EMPCODE     EGROUP1A2A3B4B5C6C

这是sqlfiddle演示