Mysql

采用：

SELECt x.client_id,        x.project_id,       x.project_name  FROM (SELECt t.client_id,    t.project_id,    t.project_name,    CASE      WHEN @client_id != t.client_id THEN @rownum := 0      WHEN @client_id = t.client_id THEN @rownum := @rownum + 1      ELSE @rownum     END AS rank,    @client_id := t.client_id          FROM TABLE t,    (SELECT @rownum := 0, @client_id      ORDER BY t.client_id) r) xORDER BY x.rank, x.client_id

MySQL没有任何排名功能，但是幸运的是您可以使用变量。关键是在client_id与先前的client_id不匹配时重置@rownum值-
子查询中的ORDER BY是为了确保客户机顺序正确。