Sql语句问题,很急,谢谢了

2025-02-25 02:31:31
推荐回答(5个)
回答1:

select name,count(请假次数) as 请假次数 from table group by name

回答2:

select name,sum(请假次数)as 请假次数 from '表名' group by name

回答3:

select name,sum(请假次数) as 请假次数 from table group by name

回答4:

select name,sum(请假次数)as 请假次数 from '表名' group by Name

回答5:

简单,SLECT * FROM 表名 WHELE name="李" and name ="赵" 如果考虑另建个表则复杂些