SQL查询到数据,如何在查询分析器里直接显示如下结果

答案:3 悬赏:40 手机版

解决时间 2021-03-17 12:09

提问者网友：暮烟疏雨之际
2021-03-17 02:06

45 ':00:00;'2010-08-26- 00; and create_time >'2010-08-26- 00.00' ;--order by create_time select count(*) editor from res_info where editor ='张2' and create_time &gt.00' ;--order by create_time select count(*) editor from res_info where editor ='张4',59,50 能直接显示成以下结果不? 张三''2010-08-26- 00:00:00; and create_time &gt.00' ;--order by create_time 上面三条语句结果分别是 45;张2' 59 张4'select count(*) editor from res_info where editor ='张三':00:00 00' ;--order by create_time select count(*) editor from res_info where editor ='zhanger' and create_time >':00.00'ps; and create_time >'2010-08-26- 00; :00:00;2010-08-26- 00:00:如果editor字段存的是拼音 select count(*) editor from res_info where editor ='zhangsan'

最佳答案

五星知识达人网友：不想翻身的咸鱼
2021-03-17 02:30

elect editor,count(*) from res_info where editor in ('张4') and create_time >'2010-08-26- 00.00' group by editor:00:00;张三','张2','

全部回答

1楼网友：神也偏爱
2021-03-17 04:17

select '张三',count(*) editor from res_info where editor ='zhangsan' and create_time >'2010-08-26- 00:00:00.00' ;--order by create_time select '张2',count(*) editor from res_info where editor ='zhanger' and create_time >'2010-08-26- 00:00:00.00' ;--order by create_time select '张4',count(*) editor from res_info where editor ='zhangsi' and create_time >'2010-08-26- 00:00:00.00' ;--order by create_time

2楼网友：一把行者刀
2021-03-17 03:36

select editor,count(*) editor from res_info where editor ='张三' and create_time >'2010-08-26- 00:00:00.00' group by editor ;--order by create_time select editor,count(*) editor from res_info where editor ='张2' and create_time >'2010-08-26- 00:00:00.00' group by editor ;--order by create_time select editor,count(*) editor from res_info where editor ='张4' and create_time >'2010-08-26- 00:00:00.00' group by editor;--order by create_time

我要举报

如以上回答内容为低俗、色情、不良、暴力、侵权、涉及违法等信息，可以点下面链接进行举报！

点此我要举报以上问答信息