教师积分兑换物品填写的收获地址

#### 日期:2019-01-15
#### 需求方:张瑾
#### 数据输出方式:excel
#### created by:汪国强
SELECT
    teacherId,
    giftName,
    giftIntegral,
    receiverRealName,
    receiverPhone,
    receiverProvince,
    receiverCity,
    receiverArea,
    receiverAddress,
    createTime
FROM
    teacher_gift_order
WHERE
    createTime  >=  '20190101'and  createTime  <  '20190114'

智优拉录音sql

#### 日期:2019-01-15
#### 需求方:张瑾
#### 数据输出方式:excel
#### created by:汪国强

SELECT
    s.student_no 学生编号,
    s.phone 手机号码
FROM
    view_student s
WHERE
    s.student_no in ()

互联拉录音sql

#### 日期:2019-01-15
#### 需求方:张瑾
#### 数据输出方式:excel
#### created by:汪国强

SELECT
    s.student_no 学生编号,
    s.phone 手机号码
FROM
    view_student s
WHERE
    s.student_no in ()
文档更新时间: 2019-03-08 11:44   作者:admin