- 博客(2)
- 收藏
- 关注
原创 数据库SQL总结
案例:select substring_index(substring_index(profile,’,’3),’,’,-1) as age_cut,count(device_id) as number from user_submit group by age;方法一:select stu.sname,sc.sdept from stu,course,sc where stu.sno=sc.sno,sc.cno=course.cno and course.cname = ‘VB’;(age保留三位小数)
2024-03-03 18:36:07 694
空空如也
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人