select case when 语文 >= 80 then '优秀' when 语文 >= 60 then '及格' else '不及格' end 语文,case when 数学 >= 80 then '优秀' when 数学 >= 60 then '及格' else '不及格' end 数学,case when 英语 >= 80 then '优秀' when 英语 >= 60 then '及格' else '不及格' end 英语 from 表 select bdate,count(case bwon when '胜' then bwon end),count(case bwon when '负' then bwon end) from 表 group by bdate
sql 中的case与group by
= 60 then '及格' else '不及格' end "}}}'>
1个回答
相关问题
-
SQL的GROUP BY错误SELECT SUM(ADMIN_ENTERED)FROM STATEGROUP BY YE
-
sql语句 group by 分组后按正序排序 只取数量最多的前五 剩下的分成一组
-
You can read faster by reading word groups.中为什么word不加s,group
-
问个group by和count()
-
the equipment being improved by the research group
-
SQL语句中的短语______。
-
-____do you study English?-By working with a group..
-
these egg were found by a group of scientists .
-
The teacher stood there,_____ by a group of people.
-
group themslves into与group them into的区别