原代码如下 想返回学生学号(STUDENT.snum)
其中有:
0148
1234
等,都是四位int,不能改变原表格式,如何显示完整的学号?谢谢。在线等
SELECt STUDENT.snum
FROM STUDENT, ENROLLED
WHERe STUDENT.snum = ENROLLED.snum
GROUP BY sname
HAVINg COUNT(ENROLLED.snum)>1;
sqlplus int数字第一位是0,如何保留
答案:2 悬赏:20 手机版
解决时间 2021-02-15 16:42
- 提问者网友:溺爱和你
- 2021-02-14 17:28
最佳答案
- 五星知识达人网友:不甚了了
- 2021-02-14 18:50
SELECt lpad(STUDENT.snum,4,0)
FROM STUDENT, ENROLLED
WHERe STUDENT.snum = ENROLLED.snum
GROUP BY sname
HAVINg COUNT(ENROLLED.snum)>1;
FROM STUDENT, ENROLLED
WHERe STUDENT.snum = ENROLLED.snum
GROUP BY sname
HAVINg COUNT(ENROLLED.snum)>1;
全部回答
- 1楼网友:有你哪都是故乡
- 2021-02-14 19:25
不明白啊 = =!
我要举报
如以上问答信息为低俗、色情、不良、暴力、侵权、涉及违法等信息,可以点下面链接进行举报!
大家都在看
推荐资讯