日期:2014-05-16 浏览次数:20684 次
sqlString = "select v.voice_file_id,time_to_sec(v.duration) as duration, " + "v.audio_channel,v.create_time, s.confidence_score,s.phrase_id, " + "time_to_sec(s.start_time) as start_time, time_to_sec(s.end_time) as end_time " + "from (select confidence_score, phrase_id, start_time, end_time, voice_file_id " + "from search_job_result limit "+(j * 100000)+",100000"+") s, voice_file v where s.voice_file_id = v.voice_file_id";