Skip to content

Instantly share code, notes, and snippets.

@limingxinleo

limingxinleo/query.sql

Last active March 9, 2022 05:02
Show Gist options
  • Save limingxinleo/d1a267a73c83d9c35d6c06a723ff3b7c to your computer and use it in GitHub Desktop.
Save limingxinleo/d1a267a73c83d9c35d6c06a723ff3b7c to your computer and use it in GitHub Desktop.
Download ZIP

Revisions

  1. limingxinleo revised this gist Mar 9, 2022. 1 changed file with 1 addition and 1 deletion.
    2 changes: 1 addition & 1 deletion query.sql
    View file
    Original file line number Diff line number Diff line change
    @@ -1,6 +1,6 @@
    # reply 表中，以 reply 分组，并查询每个分组 id 最小的前 2 条

    EXPLAIN SELECT r.*
    SELECT r.*
    FROM reply r
    WHERE r.reply_id IN (1, 2)
    AND 2 >= (
  2. limingxinleo created this gist Mar 9, 2022.
    12 changes: 12 additions & 0 deletions query.sql
    View file
    Original file line number Diff line number Diff line change
    @@ -0,0 +1,12 @@
    # reply 表中，以 reply 分组，并查询每个分组 id 最小的前 2 条

    EXPLAIN SELECT r.*
    FROM reply r
    WHERE r.reply_id IN (1, 2)
    AND 2 >= (
    SELECT COUNT(*)
    FROM reply
    WHERE reply_id = r.reply_id
    AND id <= r.id
    )
    ORDER BY r.reply_id, id;