表A
用一句SQL语句 查询表A 结果如表B 表B
SQL语句如下:
Select distinct a1.username as 姓名, (select num from userinfo a2 where a1.username=a2.username and a2.xueke='C#') as C#, (select num from userinfo a3 where a1.username=a3.username and a3.xueke='JAVA') as JAVA from userinfo a1 |
经典SQL语句汇总-2
最新推荐文章于 2024-06-09 23:10:45 发布