[Sqlite] 쿼리로 row 시퀀스 번호 select
CREATE TABLE test1(b TEXT);
INSERT INTO test1(b) VALUES('hello A');
INSERT INTO test1(b) VALUES('hello B');
INSERT INTO test1(b) VALUES('hello C');
SELECT * FROM test1;
b
hello A
hello B
hello C
select (select COUNT(0)
from test1 t1
where t1.b <= t2.b
) as 'Row Number', b from test1 t2 ORDER BY b;
Row Number|b
1|hello A
2|hello B
3|hello C
INSERT INTO test1(b) VALUES('hello A');
INSERT INTO test1(b) VALUES('hello B');
INSERT INTO test1(b) VALUES('hello C');
SELECT * FROM test1;
b
hello A
hello B
hello C
select (select COUNT(0)
from test1 t1
where t1.b <= t2.b
) as 'Row Number', b from test1 t2 ORDER BY b;
Row Number|b
1|hello A
2|hello B
3|hello C
나의일/기타
2010/10/12 16:48
댓글을 달아 주세요