经典sql语句

switch (Mode)
                {
                    case "1":
                        strSelect = "select [区站号],[" + DiscripEle + "] from tabTimeData where (日期时间= '" + dts + "') group by 区站号," + DiscripEle + "";
                            break;
                    case "2":
                        strSelect = "select tabStatElement.区站号,["+DiscripEle+"] from (select 区站号,MAX(["+DiscripEle+"]) as ["+DiscripEle+"] from tabTimeData where (日期时间>= '"+dts+"' and 日期时间<='"+dte+"') and ( right(日期时间,5)=':00AM' OR right(日期时间,5)=':00pM') group by 区站号) as tabStatElement";
                            break;
                    case "3":
                        strSelect = "select tabStatElement.区站号,[" + DiscripEle + "] from (select 区站号,MIN([" + DiscripEle + "]) as [" + DiscripEle + "] from tabTimeData where (日期时间>= '" + dts + "' and 日期时间<='" + dte + "') and ( right(日期时间,5)=':00AM' OR right(日期时间,5)=':00pM') group by 区站号) as tabStatElement";
                            break;
                    case "4":
                        strSelect = "select tabStatElement.区站号,[" + DiscripEle + "] from (select 区站号,AVG([" + DiscripEle + "]) as [" + DiscripEle + "] from tabTimeData where (日期时间>= '" + dts + "' and 日期时间<='" + dte + "') and ( right(日期时间,5)=':00AM' OR right(日期时间,5)=':00pM') group by 区站号) as tabStatElement";
                            break;
                    case "5":
                            strSelect = "select tabStatElement.区站号,[" + DiscripEle + "] from (select 区站号,SUM([" + DiscripEle + "]) as [" + DiscripEle + "] from tabTimeData where (日期时间>= '" + dts + "' and 日期时间<='" + dte + "') and ( right(日期时间,5)=':00AM' OR right(日期时间,5)=':00pM') group by 区站号) as tabStatElement";
                            break;

                    case "99"://雨量累计
                            strSelect = "select [区站号],[" + DiscripEle + "] from tabTimeData where 日期时间= '" + dts + "' group by 区站号," + DiscripEle + "";
               
                        break;
                   

                    default:
                        break;
                }