如何在SQL中同时使用LIMIT和IN来创建默认行?

你要找的是一个特定的订单条款。 试试这个

SELECT * FROM Customers order by (case when CustomerName in ('Alfreds Futterkiste') then 0 else CustomerId end) limit 30 ;

使用 UNION 合并这两个查询。

SELECT *
FROM Customers
WHERE CustomerName != 'Alfredo Futterkiste'
LIMIT 29
UNION 
SELECT *
FROM Customers
WHERE CustomerName = 'Alfreo Futterkiste'

如果要在SQL中使用默认行,那么应该在表中使用已知的主键,将该行合并到查询中:

--default row, that is always included as long as the table has a PK 1
SELECT *
FROM Customers
WHERE CustomerId = 1

UNION ALL
 
--other rows, a variable number of
SELECT *
FROM Customers
WHERE CustomerId <> 1 AND ...

LIMIT 30

以这种方式提出的限制适用于工会的结果

如果你想做一些事情,把有限的集合以其他组合组合在一起,你可能会想看看,比如

(... LIMIT 2)
UNION ALL
(... LIMIT 28)