像TSQL有選取前幾筆的語法:
select top n，如:
select top 100 * from table1 order by column1
而SQLite選取筆數的語法為:
在語法最後加上 limit n，如:
select * from table1 order by column1 limit 100延伸閱讀: How to optimise queries to limit the number of rows returned...
像TSQL有選取前幾筆的語法:
select top n，如:
select top 100 * from table1 order by column1
而SQLite選取筆數的語法為:
在語法最後加上 limit n，如:
select * from table1 order by column1 limit 100延伸閱讀: How to optimise queries to limit the number of rows returned...
沒有留言:
張貼留言