00.01. 机试小题（菱形+sql）

1.给N个摆能摆出的最大菱形并且返回剩余的数量

public static void main(String[] args) {
        Scanner input = new Scanner(System.in);
        int num;//记录*的总数
        int count = 0;//记录已经使用的*个数
        int residue = 0;//记录剩余的*个数
        int rows = 0;//记录*的总行数

        while (true){
            System.out.print("请输入*号数量：");
            num = input.nextInt();
            if (num<=0){
                System.out.println("输入值不合法==请重新输入==");
            }else {
                break;
            }
        }
        //下面的for循环可以替换为
//        if(num>=1){
//            rows = (int) Math.sqrt(num * 2 - 1);
//            count = ((int) Math.pow(rows,2)+1)/2;
//            residue = num - count;
//        }
        for (int i = 0; i < num; i++) {
            int checkNum = 2 * i * (i + 1)+1;
            //判断当行数为2*i+1时，所使用的*号的数目是否大于*总数如果不大于则赋值，大于则退出循环。
            if (checkNum<=num){
                count = checkNum;
                residue = num - checkNum;
                rows = i*2+1;
            }else if (checkNum>num){
                break;
            }
        }
        System.out.println("*数量不超过"+num+"时：画出最多的菱形");
        int n = (rows+1)/2;//上半个菱形的行数
        for (int i = 1; i <= n; i++) {//外层循环变量i控制行数
            for (int j = 1; j <= n - i; j++) {//内层循环变量j控制该行空格数
                System.out.print(" ");
            }
            for (int p = 1; p <= 2 * i - 1; p++) {//内层循环变量k控制该行*号数
                System.out.print("*");
            }
            System.out.print("\n");
        }
        //打印菱形的下半部分（下半部分菱形的行数）
        for (int i = n - 1; i >= 1; i--) {
            for (int j = 1; j <= n - i; j++) {
                System.out.print(" ");
            }
            for (int q = 1; q <= 2 * i - 1; q++) {
                System.out.print("*");
            }
            System.out.print("\n");
        }
        System.out.println("菱形行数为："+rows);
        System.out.println("剩余*号数量为："+residue);
    }

2 . 查询有满分的学生并且根据学生姓名排序

SELECT `name` FROM tbl_middle_student 
WHERE id IN(SELECT stu_id FROM tbl_middle_score WHERE score=100 GROUP BY stu_id)
ORDER BY `name`

SELECT `name` FROM tbl_middle_student 
WHERE id IN(SELECT stu_id FROM tbl_middle_score GROUP BY stu_id HAVING Max(score)=100)
ORDER BY `name`

SELECT `name` FROM tbl_middle_student s1
RIGHT JOIN (SELECT stu_id FROM tbl_middle_score s2 GROUP BY stu_id HAVING Max(score)=100) s2
ON s1.id=s2.stu_id
ORDER BY `name`

SELECT `name` FROM tbl_middle_student s1
RIGHT JOIN (SELECT stu_id FROM tbl_middle_score WHERE score=100 GROUP BY stu_id) s2
ON s1.id=s2.stu_id
ORDER BY `name`

3. 查询每个班身高最高的学生按照班级排序
   

select 
cl.`name` classname, st.`name`, st.height
from
(select st1.classid, max(st1.height) height from tbl_middle_student st1 GROUP BY st1.classid) temp,
tbl_middle_student st,
tbl_middle_class cl
where temp.classid=st.classid and temp.height=st.height and cl.id = st.classid
order by st.classid

数据库sql下载地址
链接：https://pan.baidu.com/s/1uMIOtfwfITMUJB3OH3C13w
提取码：3djd
复制这段内容后打开百度网盘手机App，操作更方便哦