你可能感兴趣的试题
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
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
set up put up stay up stand up
Class Two, Grade one Class two ,grade one Grade One, Class Two Class Two, Grade One
grade one, class two class two, grade one Grade One, Class Two Class Two, Grade One
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
tall taller tallest the taller
class two Class Two Two Class two class