![](https://img-blog.csdnimg.cn/20201014180756916.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
sql
艺菲
这个作者很懒,什么都没留下…
展开
-
达梦8,sql取得所有表,所有字段,主键,自增
1.获得某个用户下,所有表名,表注释,创建时间,修改时间select a.object_name as table_name,b.comment$ as table_comment,a.created as create_time,a.last_ddl_time as update_timefrom dba_objects aleft join SYSTABLECOMMENTS b on b.tvname = a.object_namewhere a.object_type = 'TABLE'原创 2021-07-27 13:12:12 · 5557 阅读 · 1 评论 -
1对多,多个数取最新一条
select a.PK_T_OH_OHO,a.ohid,c.name as deptName,b.emp_id,b.name,d.dict_label as sex,b.id,b.phonenumber,a.team,b.tw,a.od_time,a.remark, e.actstat, e.uuid, a.APP_TIME, nvl( (.原创 2021-07-21 14:50:37 · 263 阅读 · 0 评论 -
一对多关联查询,结果为一条,各字段逗号链接
结果sql语句select a.pk_t_oh_oho,c.name,wm_concat(distinct g.name)as coh,wm_concat(distinct i.name)as oc, wm_concat(distinct k.name)as cod, wm_concat(distinct m.dict_label) as pmfrom t_oh_oho ainner join sys_user b on b.user_id = a.fk_sys_user.原创 2021-07-20 09:04:32 · 255 阅读 · 0 评论 -
oracle使用listagg查询电影数据
需求 电影名、类别、播放次数、评分已知的表结构MOVIE表MOVIE_IDTITLEYEARBUDGETGROSSPLOT_SUMMARYMOVIE_GENRE表MOVIE_IDGENER_IDGENRE表GENRE_IDNAMEMOVIE_FACT表CUST_IDMOVIE_IDGENRE_IDACTIV原创 2016-09-02 08:54:49 · 466 阅读 · 0 评论