Re: [SQL ] 選取特定主鍵跟其下一筆之外的資料
※ 引述《JYHuang (夏天到了，冷不起來了說)》之銘言：
: ※ 引述《arrack (艾瑞克)》之銘言：
: : select news.* from news,
: : (select id from news where id=10 order by id limit 1 ) as a ,
: : (select id from news where id>10 order by id limit 1 ) as b
: : where news.id<>a.id and news.id<>b.id order by news.id
: : 但是我只能說 效能慘不睹:)
: 感謝arrack版友的幫忙測試
: 我看我還是認份點，分兩次來取好了 = ="
: 不然要是遇到排除的筆數更多時....鐵定是慘上加慘
: 把排除的跟全部的都取出，再做差集..
這樣呢？
SELECT A.id FROM news AS A LEFT JOIN
(SELECT id FROM news WHERE id >= 10 ORDER BY id LIMIT 2) AS B
ON A.id = B.id WHERE B.id IS NULL
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 219.81.198.75
推
06/25 21:01, , 1F
06/25 21:01, 1F
推
06/25 21:06, , 2F
06/25 21:06, 2F
推
06/26 00:50, , 3F
06/26 00:50, 3F
→
06/26 01:21, , 4F
06/26 01:21, 4F
→
06/26 01:22, , 5F
06/26 01:22, 5F
推
06/26 11:10, , 6F
06/26 11:10, 6F
討論串 (同標題文章)
完整討論串 (本文為第 4 之 7 篇)：