mainform.ado2.SQL.Add('select riqi as 日期, 雪 as 雪'); mainform.ado2.SQL.Add(' from '+TableTq); mainform.ado2.SQL.Add(' where 雪 not in (select 雨 from '+TableTq+' where 雪=雨) and substring(riqi,5,4) between '''+formatdatetime('mmdd',DateTimePicker2.Date)+''''); mainform.ado2.sql.Add(' and '''+formatdatetime('mmdd',DateTimePicker4.Date)+''''); mainform.ado2.sql.Add(' and substring(riqi,1,4) between '''+formatdatetime('yyyy',DateTimePicker1.Date)+''''); mainform.ado2.sql.Add(' and '''+formatdatetime('yyyy',DateTimePicker3.Date)+''''); mainform.ado2.sql.Add(' and QuZhanHao='''+StationId+''''); mainform.ado2.sql.Add(' order by riqi');
uj5u.com熱心網友回復：
mainform.ado2.SQL.Add('select riqi as 日期, 雪 as 雪');
mainform.ado2.SQL.Add(' from '+TableTq);
mainform.ado2.SQL.Add(' where 雪 not in (select 雨 from '+TableTq+' where 雪=雨) and substring(riqi,5,4) between '''+formatdatetime('mmdd',DateTimePicker2.Date)+'''');
mainform.ado2.sql.Add(' and '''+formatdatetime('mmdd',DateTimePicker4.Date)+'''');
mainform.ado2.sql.Add(' and substring(riqi,1,4) between '''+formatdatetime('yyyy',DateTimePicker1.Date)+'''');
mainform.ado2.sql.Add(' and '''+formatdatetime('yyyy',DateTimePicker3.Date)+'''');
mainform.ado2.sql.Add(' and QuZhanHao='''+StationId+''''); mainform.ado2.sql.Add(' order by riqi');
uj5u.com熱心網友回復：
我想查詢出出現雪的日期（去除出現雨與雪相同日期），該怎么做，求高手幫忙。轉載請註明出處，本文鏈接：https://www.uj5u.com/houduan/134448.html
標籤：語言基礎/算法/系統設計