SELECT * FROM COMPANY INDEXED BY salary_index WHERE salary > 5000;

 

INDEXED BY salary_index
这个才是sqlite的用法

参考：https://www.runoob.com/sqlite/sqlite-indexed-by.html