美文网首页
sqlite(7)-表达式

sqlite(7)-表达式

作者: Flannery | 来源:发表于2016-06-15 18:00 被阅读0次

    语法#

    SELECT column1, column2, columnN
    FROM table_name
    WHERE [CONTION | EXPRESSION];

    布尔表达式#

    SELECT * FROM COMPANY WHERE SALARY = 10000;

    数值表达式#

    SELECT numerical_expression as OPERATION_NAME
    [FROM table_name WHERE CONDITION];

    --

    SELECT (15 / 6) AS ADDITION
    SELECT COUNT(*) AS "RECORDS" FROM COMPANY;

    日期表达式#

    SELECT CURRENT_TIMESTAMP;

    相关文章

      网友评论

          本文标题:sqlite(7)-表达式

          本文链接:https://www.haomeiwen.com/subject/bhcpdttx.html