sqllite sql语句

1.select语句

 

SELECT column1, column2, columnN FROM table_name;, column2, columnN FROM table_name;

WHERE AGE >= 25 AND SALARY >= 65000;>= 25 AND SALARY >= 65000;

<strong>WHERE AGE IS NOT NULL<span style="color:#666600">;</span></strong>

WHERE AGE >= 25 OR SALARY >= 65000;>= 25 OR SALARY >= 65000;

WHERE NAME LIKE 'Ki%'; 'Ki%'; 

<strong>WHERE NAME GLOB <span style="color:#008800">'Ki*'</span><span style="color:#666600">;    </span></strong>

 WHERE AGE IN ( 25, 27 );( 25, 27 );

<strong>WHERE AGE NOT IN <span style="color:#666600">(</span><span style="color:#000000"> </span><span style="color:#006666">25</span><span style="color:#666600">,</span><span style="color:#000000"> </span><span style="color:#006666">27</span><span style="color:#000000"> </span><span style="color:#666600">);</span></strong>

WHERE AGE BETWEEN 25 AND 27;25 AND 27;

WHERE EXISTS (SELECT AGE FROM COMPANY WHERE SALARY > 65000);(SELECT AGE FROM COMPANY WHERE SALARY > 65000);

WHERE AGE > (SELECT AGE FROM COMPANY WHERE SALARY > 65000);> (SELECT AGE FROM COMPANY WHERE SALARY > 65000);

ORDER BY SALARY ASC;;

ORDER BY NAME DESC;;