统计限定条件下某数据的总和

最新推荐文章于 2021-04-20 10:56:04 发布

原创最新推荐文章于 2021-04-20 10:56:04 发布 · 169 阅读

0 ·

CC 4.0 BY-SA版权

本文提供了一个SQL查询示例，用于从员工表中筛选出年龄大于等于40岁的员工及其总工资，并按总工资降序排列。该查询涉及多表连接、分组及排序等操作。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

        private void button5_Click(object sender, EventArgs e)
        {
            string s = "select employee.empno as 员工号,employee.empname as 姓名,";
            s += "employee.empage as 年龄,sum(works.salary) as 总工资 ";
            s += "from employee,works where employee.empno=works.empno ";
            s += "and employee.empage>=40 ";
            s += "group by employee.empno,employee.empname,employee.empage ";
            s += "order by sum(works.salary) desc";
            loadLV(listView2,s);
        }