sqlite 使用过的sql语句

// 导出基准值表查询 data_ad （不用了）
    // 以时间查询sql语句
    // select *
    // from data_ad
    // where id  in (
    //      select id from (
    //      SELECT id, substr(ID, 1, instr(ID, '_') - 1) AS datetime_part,    substr(ID, instr(ID, '_') + 1) AS index_part FROM data_ad WHERE datetime_part >= "20240101000000" AND datetime_part <= "20240625091000"))
    // order by id 【注：对返回的结果进行正向排序】

    // 根据sn查询sql记录
    // select *
    // from data_ad
    // where id  in (
    //     select id from (
    //     SELECT id, substr(ID, 1, instr(ID, '_') - 1) AS tasktime,    substr(ID, instr(ID, '_') + 1) AS sn FROM data_ad WHERE sn = "2"))
    //

//  导出系数表查询  data_ratio （不用了）
    // 根据时间查询
    // select *
    // from data_ratio
    // where id  in (
    // select id from (
    // SELECT id, substr(ID, 1, instr(ID, '_') - 1) AS datetime_part,    substr(ID, instr(ID, '_') + 1) AS index_part
    //       FROM data_ratio WHERE datetime_part >= "20240101001000" AND datetime_part <= "20240101100000"))
    // order by id, IndexN 【注：对返回的结果进行正向排序】

    // 根据sn查询
    // select *
    // from data_ratio
    // where id  in (
    // select id from (
    //     SELECT id, substr(ID, 1, instr(ID, '_') - 1) AS tasktime,    substr(ID, instr(ID, '_') + 1) AS sn FROM data_ratio WHERE sn = "2"))


// 导出测试结果查询 data_result （不用了）
    // 根据时间查询
    // select *
    // from data_result
    // where id  in (
    // select id from (
    // SELECT id, substr(ID, 1, instr(ID, '_') - 1) AS taskTime,    substr(ID, instr(ID, '_') + 1) AS sn
    //     FROM data_result WHERE taskTime >= "20240101000000" AND taskTime <= "20240101100000"))

    // 根据sn查询
    // select *
    // from data_result
    // where id  in (
    // select id from (
    //     SELECT id, substr(ID, 1, instr(ID, '_') - 1) AS tasktime,    substr(ID, instr(ID, '_') + 1) AS sn FROM data_result WHERE sn = "2"))


// 导出测试结果明细 data_result_list  （不用了）
    // 根据时间查询
    // select *
    // from data_result_list
    // where id  in (
    // select id from (
    // SELECT id, substr(ID, 1, instr(ID, '_') - 1) AS datetime_part,    substr(ID, instr(ID, '_') + 1) AS index_part
    //     FROM data_result_list WHERE datetime_part >= "20240101001000" AND datetime_part <= "20240101100000"))

    // sn查询
    // select *
    // from data_result_list
    // where id  in (
    // select id from (
    // SELECT id, substr(ID, 1, instr(ID, '_') - 1) AS tasktime,    substr(ID, instr(ID, '_') + 1) AS sn FROM data_result_list WHERE sn = "2"))

// 使用这条sql语句进行查询，获取唯一id
    // 通过sn查询
    // select id, substr(ID, instr(ID, '_') + 1) as SN,  substr(ID, 1, instr(ID, '_') - 1) as TaskTime
    //  from
    //  (
    //      select id, substr(ID, instr(ID, '_') + 1) as SN from data_ad where sn = "2"
    //      union all
    //      select id, substr(ID, instr(ID, '_') + 1) as SN from data_ratio where sn = "2"
    //      union all
    //      select id, substr(ID, instr(ID, '_') + 1) as SN from data_result where sn = "2"
    //      union all
    //      select id, substr(ID, instr(ID, '_') + 1) as SN from data_result_list where sn = "2"
    //      union all
    //      select id, substr(ID, instr(ID, '_') + 1) as SN from data_waveform where sn = "2"
    //  )
    // group by id

    // 通过时间查询
    // select id, substr(ID, 1, instr(ID, '_') - 1) as TaskTime, substr(ID, instr(ID, '_') + 1) as SN
    //     from
    //     (
    //         select id, substr(ID, 1, instr(ID, '_') - 1) as TaskTime from data_ad where TaskTime >= "20240100000000" AND TaskTime <= "20240901100000"
    //         union all
    //         select id, substr(ID,  1,instr(ID, '_') - 1) as TaskTime from data_ratio where TaskTime >= "20240100000000" AND TaskTime <= "20240901100000"
    //         union all
    //         select id, substr(ID,  1,instr(ID, '_') - 1) as TaskTime from data_result where TaskTime >= "20240100000000" AND TaskTime <= "20240901100000"
    //         union all
    //         select id, substr(ID,  1,instr(ID, '_') - 1) as TaskTime from data_result_list where TaskTime >= "20240100000000" AND TaskTime <= "20240901100000"
    //         union all
    //         select id, substr(ID, 1,instr(ID, '_') - 1) as TaskTime from data_waveform where TaskTime >= "20240100000000" AND TaskTime <= "20240901100000"
    //     )
    //     group by id
    //     order by id