经典sql语句

来源：互联网发布：笔记本电脑手写软件编辑：程序博客网时间：2024/06/05 12:38

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;
                }