检索选修四门以上课程的学生总成绩(不统计不及格的课程),并要求按总成绩的降序排列出来。正确的SELECT语句是( )。
A:SELECT S#,SUM(GRADE)FROM SC B:WHERE GRADE>=60 C:GROUP BY S# D:ORDER BY 2 DESC E:HAVING COUNT(*)>=4 F:SELECT S#,SUM(GRADE)FROM SC G:WHERE GRADE>=60 H:GROUP BY S# I:HAVING COUNT(*)>=4 J:ORDER BY 2 DESC K:SELECT S#,SUM(GRADE)FROM SC L:WHERE GRADE>=60 M:HAVING COUNT(*)>=4 N:GROUP BY S#
下面程序段的输出结果是
public class Test
public static void main(String args[])
int n=5,sum=O;
while(n>0)
sum+=n;
--n;
System.out.println("sum is "+Sum);
A:sum is 14 B:sum is 15 C:sum is 10 D:sum is 5
以下C程序的运行结果为______。
main( )
int i=1,sum=0;
loop:if(i<=10)
sum+=i;
i++;
goto loop;
printf("sum=%d/n",sum);
A:sum=10 B:sum=55 C:sum=100 D:sum=88
以下程序段的执行结果为______。 #define PLUS(X,Y)X+Y main( ) { int x=1,y=2,z=3,sum; sum=PLUS(x+y,z)*PLUS(y,z); printf("SUM=%d",sum); }
A:SUM=9 B:SUM=12 C:SUM=18 D:SUM=28
下面程序段的输出结果是 public class Test{ public static void main(String args[]){ int n=5,sum=O; while(n>0){ sum+=n; --n; } System.out.println("sum is "+Sum); } }
A:sum is 14 B:sum is 15 C:sum is 10 D:sum is 5
下面程序段的输出结果是 public class Test{ public static void main(String args[]){ int n=5,sum=0; while(n>0){ sum+=n; --n; } System.out.println("sum is"+sum); } }
A:sum is 14 B:sum is 15 C:sum is 10 D:sum is 5
下列程序的执行结果是______。 public class ex3 { public static void main(String[] args) { int sum=0; for(int i=1;i<=100;i++) { sum+=i; } System.out.println("sum="+sum); }
A:sum=5050 B:sum=4950 C:sum=100 D:sum=1
下面程序段的输出结果是( )。 public class Test { public static void main (String[] args) { int sum=0; for ( int i=0;i<=100; i++) sum+=i; System. out. println ("sum="+sum); } }
A:sum =5050 B:sum=4950 C:sum=0 D:sum=100
下列程序的输出结果是( )。 public class Test { public static void main (String[] args) { int n=5,sum=0; while (n>0) { sum+=n; --n; } System.out.println("Sum is"+sum); } }
A:sum is 14 B:sum is 15 C:sum is 10 D:sum is 5
检索选修四门以上课程的学生总成绩(不统计不及格的课程),并要求按总成绩的降序排列出来。正确的SELECT语句是______。
A:SELECT S#, SUM(GRAD FROM SC WHERE GRADE>=60 GROUP BY S# ORDER BY 2 DESC HAVING COUNT(*)>=4 B:SELECT S#, SUM(GRAD FROM SC WHERE GRADE>=60 GROUP BY S# HAVING COUNT(*)>=4 ORDER BY 2 DESC C:SELECT S#, SUM(GRAD FROM SC WHERE GRADE>=60 HAVING COUNT(*)>=4 GROUP BY S# ORDER BY 2 DESC D:SELECT S#, SUM(GRADFROM SC WHERE GRADE>=60 ORDER BY 2 DESC GROUP BY S# HAVING COUNT(*)>=4