sqlite(7)-表达式
2016-06-15 本文已影响0人
Flannery
语法#
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;
