mysql - 选择 Mariadb 中除顶行以外的所有行

Question

如何从表中返回除第一行以外的所有行。这是我的 sql 语句:

SELECT * FROM article  where article_no 
NOT IN
(SELECT * FROM article   order by article_no  limit 1)

上面给定的 SQL 查询抛出一个错误:

This version of MariaDB doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery'

Answer 1

子查询必须只选择你需要比较的列:

SELECT *
FROM article
WHERE article_no NOT IN (
    SELECT article_no
    FROM article
    ORDER BY article_no
    LIMIT 1
)

上述查询在 MySQL 中有效，但在 MariaDB 中无效，doesn't currently support LIMIT in subqueries .我会像这样重写子查询:

SELECT *
FROM article
WHERE article_no NOT IN (SELECT MIN(article_no) FROM article)