SQL心得

selece * from table A 

时取别名A有利于下次嵌套一层select

大神的sql

SELECT 
  *
FROM
  (SELECT 
    @ROWNUM := @ROWNUM + 1 AS ROWNUM,
    H.* 
  FROM
    qc_approval_history H,
    (SELECT 
      @ROWNUM := 0) A 
where APPROVAL_STATUS = 0
  ORDER BY H.`FOREIGN_ID`,
    H.`APPROVER_ORDER`) AH 
GROUP BY AH.FOREIGN_ID 
ORDER BY AH.ROWNUM ;