-- http://o...content-available-to-author-only...e.jp/qa/8440180.html
create table card (
n integer primary key, A text, B text, C text
);
insert into card values (1, 'A1', 'B3', 'C1');
insert into card values (3, 'A2', 'B3', 'C2');
insert into card values (5, 'A2', 'B3', 'C3');
insert into card values (7, 'A3', 'B3', 'C2');
insert into card values (9, 'A1', 'B1', 'C1');
insert into card values (11, 'A3', 'B2', 'C3');
insert into card values (13, 'A3', 'B1', 'C2');
insert into card values (15, 'A1', 'B2', 'C1');
insert into card values (17, 'A3', 'B1', 'C2');
insert into card values (19, 'A3', 'B3', 'C1');
insert into card values (21, 'A3', 'B1', 'C3');
insert into card values (23, 'A3', 'B2', 'C3');
insert into card values (25, 'A3', 'B2', 'C2');
insert into card values (27, 'A1', 'B1', 'C2');
insert into card values (29, 'A3', 'B1', 'C3');
insert into card values (31, 'A1', 'B3', 'C1');
insert into card values (33, 'A2', 'B2', 'C1');
insert into card values (35, 'A3', 'B1', 'C1');
insert into card values (37, 'A3', 'B3', 'C2');
insert into card values (39, 'A2', 'B1', 'C3');
insert into card values (41, 'A2', 'B3', 'C1');
insert into card values (43, 'A3', 'B2', 'C3');
insert into card values (45, 'A1', 'B2', 'C3');
insert into card values (47, 'A1', 'B2', 'C2');
insert into card values (49, 'A1', 'B1', 'C2');
insert into card values (51, 'A1', 'B2', 'C1');
 
.mode column
select '--全データ';
.header ON
select *,(select count(*)+1 from card as c where c.n < card.n) as idx from card;
 
.header OFF
select '--Bが''B1''かつ順位が10位以上';
.header ON
select * from (select *,(select count(*)+1 from card as c where c.n < card.n) as idx from card)
where B = 'B1' and idx <= 10;
 

LS0gaHR0cDovL28uLi5jb250ZW50LWF2YWlsYWJsZS10by1hdXRob3Itb25seS4uLmUuanAvcWEvODQ0MDE4MC5odG1sCmNyZWF0ZSB0YWJsZSBjYXJkICgKbiBpbnRlZ2VyIHByaW1hcnkga2V5LCBBIHRleHQsIEIgdGV4dCwgQyB0ZXh0Cik7Cmluc2VydCBpbnRvIGNhcmQgdmFsdWVzICgxLCAnQTEnLCAnQjMnLCAnQzEnKTsKaW5zZXJ0IGludG8gY2FyZCB2YWx1ZXMgKDMsICdBMicsICdCMycsICdDMicpOwppbnNlcnQgaW50byBjYXJkIHZhbHVlcyAoNSwgJ0EyJywgJ0IzJywgJ0MzJyk7Cmluc2VydCBpbnRvIGNhcmQgdmFsdWVzICg3LCAnQTMnLCAnQjMnLCAnQzInKTsKaW5zZXJ0IGludG8gY2FyZCB2YWx1ZXMgKDksICdBMScsICdCMScsICdDMScpOwppbnNlcnQgaW50byBjYXJkIHZhbHVlcyAoMTEsICdBMycsICdCMicsICdDMycpOwppbnNlcnQgaW50byBjYXJkIHZhbHVlcyAoMTMsICdBMycsICdCMScsICdDMicpOwppbnNlcnQgaW50byBjYXJkIHZhbHVlcyAoMTUsICdBMScsICdCMicsICdDMScpOwppbnNlcnQgaW50byBjYXJkIHZhbHVlcyAoMTcsICdBMycsICdCMScsICdDMicpOwppbnNlcnQgaW50byBjYXJkIHZhbHVlcyAoMTksICdBMycsICdCMycsICdDMScpOwppbnNlcnQgaW50byBjYXJkIHZhbHVlcyAoMjEsICdBMycsICdCMScsICdDMycpOwppbnNlcnQgaW50byBjYXJkIHZhbHVlcyAoMjMsICdBMycsICdCMicsICdDMycpOwppbnNlcnQgaW50byBjYXJkIHZhbHVlcyAoMjUsICdBMycsICdCMicsICdDMicpOwppbnNlcnQgaW50byBjYXJkIHZhbHVlcyAoMjcsICdBMScsICdCMScsICdDMicpOwppbnNlcnQgaW50byBjYXJkIHZhbHVlcyAoMjksICdBMycsICdCMScsICdDMycpOwppbnNlcnQgaW50byBjYXJkIHZhbHVlcyAoMzEsICdBMScsICdCMycsICdDMScpOwppbnNlcnQgaW50byBjYXJkIHZhbHVlcyAoMzMsICdBMicsICdCMicsICdDMScpOwppbnNlcnQgaW50byBjYXJkIHZhbHVlcyAoMzUsICdBMycsICdCMScsICdDMScpOwppbnNlcnQgaW50byBjYXJkIHZhbHVlcyAoMzcsICdBMycsICdCMycsICdDMicpOwppbnNlcnQgaW50byBjYXJkIHZhbHVlcyAoMzksICdBMicsICdCMScsICdDMycpOwppbnNlcnQgaW50byBjYXJkIHZhbHVlcyAoNDEsICdBMicsICdCMycsICdDMScpOwppbnNlcnQgaW50byBjYXJkIHZhbHVlcyAoNDMsICdBMycsICdCMicsICdDMycpOwppbnNlcnQgaW50byBjYXJkIHZhbHVlcyAoNDUsICdBMScsICdCMicsICdDMycpOwppbnNlcnQgaW50byBjYXJkIHZhbHVlcyAoNDcsICdBMScsICdCMicsICdDMicpOwppbnNlcnQgaW50byBjYXJkIHZhbHVlcyAoNDksICdBMScsICdCMScsICdDMicpOwppbnNlcnQgaW50byBjYXJkIHZhbHVlcyAoNTEsICdBMScsICdCMicsICdDMScpOwoKLm1vZGUgY29sdW1uCnNlbGVjdCAnLS3lhajjg4fjg7zjgr8nOwouaGVhZGVyIE9OCnNlbGVjdCAqLChzZWxlY3QgY291bnQoKikrMSBmcm9tIGNhcmQgYXMgYyB3aGVyZSBjLm4gPCBjYXJkLm4pIGFzIGlkeCBmcm9tIGNhcmQ7CgouaGVhZGVyIE9GRgpzZWxlY3QgJy0tQuOBjCcnQjEnJ+OBi+OBpOmghuS9jeOBjDEw5L2N5Lul5LiKJzsKLmhlYWRlciBPTgpzZWxlY3QgKiBmcm9tIChzZWxlY3QgKiwoc2VsZWN0IGNvdW50KCopKzEgZnJvbSBjYXJkIGFzIGMgd2hlcmUgYy5uIDwgY2FyZC5uKSBhcyBpZHggZnJvbSBjYXJkKQp3aGVyZSBCID0gJ0IxJyBhbmQgaWR4IDw9IDEwOwo=