Mysql按分组获取前几条内容

来源:互联网 发布:网络十大热词 英文 编辑:程序博客网 时间:2024/06/16 09:04
$sql_set = "SET @num := 0,@GROUP := '';";
$sql = "SELECT
                *
            FROM
                (
                    SELECT
                        *, @num :=
                    IF (
                        @GROUP = `group_name`,
                        @num + 1,
                        1
                    ) AS row_number,
                    @GROUP := `group_name`
                FROM
                    v2_order
                WHERE
             group_name IS NOT NULL
                ORDER BY
                    group_name,
                    o_id DESC
                ) AS tmp
            WHERE
                tmp.row_number <= 20 ";
原创粉丝点击