你可能感兴趣的试题
SELECT sno FROM sc WHERE sname="数据库"AND grade=MAX(grad SELECT sno FROM sc FOR sname="数据库"OR grade>=MAX(grad SELECT sno FROM sc WHERE sname="数据库"AND grade=(SELECT MAX(grad FROM s SELECT sno FROM sc FOR sname="数据库"OR grade=(SELECT MAX(grad FROM s
SELECT sno FROM sc WHERE sname="数据库"AND grade=MAX(grad SELECT sno FROM sc FOR sname="数据库"OR grade>=MAX(grad SELECT sno FROM sc WHERE sname="数据库"AND grade=(SELECT MAX (grad FROM s SELECT sno FROM sc FOR sname="数据库" OR grade=(SELECT MAX (grad FROM s
a; the a; a the; the the; a
SELECT S#, SUM(GRAD FROM SC WHERE GRADE>=60 GROUP BY S# ORDER BY 2 DESC HAVING COUNT(*)>=4 SELECT S#, SUM(GRAD FROM SC WHERE GRADE>=60 GROUP BY S# HAVING COUNT(*)>=4 ORDER BY 2 DESC SELECT S#, SUM(GRAD FROM SC WHERE GRADE>=60 HAVING COUNT(*)>=4 GROUP BY S# ORDER BY 2 DESC SELECT S#, SUM(GRADFROM SC WHERE GRADE>=60 ORDER BY 2 DESC GROUP BY S# HAVING COUNT(*)>=4
SELECT Sno,AVG(Grad FROM SC WHERE AVG(Grad>=90 GROUP BY Sno SELECT Sno,AVG(Grad FROM SC GROUP BY Sno HAVING AVG(Grad>=90 SELECT Sno,AVG(Grad FROM SC WHERE AVG(Grad>=90 ORDER BY Sno SELECT Sno,AVG(Grad FROM SC GROUP BY Cno HAVING AVG(Grad>=90
INSERT INTO SC(SNO, CNO, GRAD VALUES('S101', 'C11', '98') INSERT INTO SC(SNO, CNO, GRAD VALUES(S101, C11, 98) INSERT('Sl01', 'C11', '98')INTO SC INSERT INTO SC VALUES('S101', 'C11', 98)
Select C#,AVG(grad From SCG Group by grade Order by 2,C# Desc Select C#,AVG(grad From SCG Group by C# Order by 2,C# Desc Select C#,AVG(grad From SCG Where C#,AVG Desc Group by grade Select C#,AVG(grad From SCG Group by AVG(grad Order by 2,C# Desc
{(Sno,Sname,Cno,Tname,Tadd,(Sno,Sname,Cno,Cname,Grad)属于2NF {(Sno,Snam,(Sno,Cno,Grade Tname,Tadd,(Cno,Cnam}属于2NF {(Sno,Snam,(Sno,Cno,Grad,(Tname,Tadd,(Cno,Cnam}属于3NF {(Sno,Snam,(Sno,Cno,Grad,(Tname,Tadd,(Tname,Cn,(Cno,Cnam}属于3NF