面试之基础题目

第一步：取得每一个部门的平均薪水
select deptno ,avg(sal) as avgsal from emp group by deptno；
第二步：取得平均薪水的最大值
select avg(sal) avgsal from emp group by deptno  order by avgsal desc limit 1;
第三步：第一步和第三步联合
select
deptno,avg(sal) as avgsal
from
emp
group by  deptno
having avg(sal)=(select avg(sal) avgsal from emp group by deptno order by avgsal desc limit 1);

SELECT t.date,
sum(case when t.result='胜' then 1 else 0 end) '胜',
sum(case when t.result='负' then 1 else 0 end) '负'
from record t GROUP BY t.date

public class Factorial {

    /**
     * 输出从1到10的阶乘之和
     * @param args
     */
    public static void main(String[] args) {

        int sum = 0;
        for (int i = 1; i <=10; i++) {
            int  factorial = 1;
            for (int j = 1; j <= i ; j++) {
                factorial*=j;
            }
            sum +=factorial;
        }
        System.out.println(sum);
    }
}