1. 插入到SQL查询中的CASE语句
示例1:
SELECT name, number,
CASE
WHEN num <= 10 AND score >= 75 THEN @lc_num1
WHEN num <= 25 AND score >= 50 THEN @lc_num2
ELSE @lc_num3
END AS lt_student
FROM ztsm_student
WHERE number = @number
INTO CORRESPONDING FIELDS OF TABLE @table_of_student.
备注:1.必须在变量或者常量前面加上@符号,以便让编译器知道讨论的不是数据库的字段。
2.数据库检索字段之间添加逗号。
3.结尾处添加INTO语句。
2. SQL语句 中的计算
示例2:
SELECT name , number ,
CAST(score AS FLTP) / CAST(num AS FLTP)
AS ratio
FROM ztsm_student
WHERE number = @number
INTO CORRESPONDING FIELDS OF TABLE @table_of_student.
3. WHERE字句的改进
示例3:
SELECT a , b, c
FROM zt_table
WHERE e + f > 100
INTO TABLE @DATA(lt_table).
示例4:
SELECT a , b, c
FROM zt_table
WHERE g = &