SQL面试题汇总.docVIP

已经知道原表year salary------------------ ---------------------2000 10002001 20002002 30002003 4000显示查询结果year salary------------------ ---------------------2000 10002001 30002002 60002003 10000第一种：select b.year,sum(a.salary) from salary a,salary b where a.year=b.year group by b.year order by b.year;第二种：select s1.year year,(select sum(s2.salary) from salary s2 where s2.year=s1.year) salary from salary s1; 2．一道SQL语句面试题，关于group by表内容：2005-05-09 胜2005-05-09 胜2005-05-09 负2005-05-09 负2005-05-10 胜2005-05-10 负2005-05-10 负如果要生成下列结果, 该如何写sql语句??????????? 胜 负2005-05-09 2 22005-05-