Repeat statements optimized sqlite subqueries-CodePudding

Home > database > Repeat statements optimized sqlite subqueries

Repeat statements optimized sqlite subqueries

Time：09-24

program, the use of SQL query in the two areas are to use this statement at the bottom of the return value of SQLITE does not support stored procedure cannot set variables, and don't want to perform this statement query operation, have what good method?
If it's convenient, would you please give a instance, thank you,

 SELECT Count (*) from the Employee where Salary & gt; 5000;

CodePudding user response: