记录oracle常用的sql语句

版权声明:本文为博主原创文章,遵循 CC 4.0 BY-SA 版权协议,转载请附上原文出处链接和本声明。
本文链接:https://blog.csdn.net/ShadowerWArden/article/details/82782605
//查询businessid字段,数据量大于1 count>1
select businessid,count(*) from picture_library t group by businessid having count(*)>1;
//按时间降序(desc)排列,升序为asc
select t.*,rowid from picture_library t order by t.time desc;
//查询table表中 code字段为0或者4的数据
select t.*,rowid from table where code in(0,4);

 

展开阅读全文

没有更多推荐了,返回首页