新乡民调(来自息县民调) - 主标

sql_20180428.sql 474B

1234567891011121314
  1. select * from T_Call_OutTask
  2. select * from T_Ask_Question
  3. select * from dbo.T_Call_OutTaskTelNum
  4. select * from dbo.T_Call_OutAnswers
  5. SELECT* FROM T_Ask_QuestionItems
  6. where F_QuestionId = (select F_QuestionId from T_Ask_Question
  7. where F_Title='Q1、请问您对所在地的社会治安状况的评价是:')
  8. select count(1) FROM T_Call_OutTaskTelNum
  9. where DATEDIFF(day,ExpandDatField1,'2017-04-02')<=0
  10. and DATEDIFF(day,ExpandDatField1,'2017-05-15')>=0
  11. and ExpandIntField1='514'