程式學習日記，如果我幫助了你請讓我知道

1.

select a.id,a.title from ((select id,title from articles  limit 5) union (select c.id,c.title  from (select id,title from articles  limit 15,5) as c  order by c.id desc )  ) as a

order by 後沒 Limit 無法看到效果

1    QUO PORRO
2    QUIBUSDAM EX NIHIL
3    ET AT
4    QUAS TENETUR QUI QUO
5    ODIO OFFICIIS UT FUGIT EOS
16    ISTE QUIA RERUM QUI
17    VOLUPTATEM ACCUSANTIUM OMNIS CORPORIS
18    ASSUMENDA OMNIS ET QUISQUAM
19    ILLUM NECESSITATIBUS SUNT

2.

select a.id,a.title from ((select id,title from articles  limit 5) union (select c.id,c.title  from (select id,title from articles  limit 15,5) as c  order by c.id desc limit 5 )  ) as a

要加limit

1    QUO PORRO
2    QUIBUSDAM EX NIHIL
3    ET AT
4    QUAS TENETUR QUI QUO
5    ODIO OFFICIIS UT FUGIT EOS
20    FUGIT AUT
19    ILLUM NECESSITATIBUS SUNT
18    ASSUMENDA OMNIS ET QUISQUAM
17    VOLUPTATEM ACCUSANTIUM OMNIS CORPORIS