摘要:
--1:无ORDER BY排序的写法。(效率最高) --(经过测试,此方法成本最低,只嵌套一层,速度最快!即使查询的数据量再大,也几乎不受影响,速度依然!) SELECT * FROM (SELECT ROWNUM AS rowno, t.* FROM emp t WHERE hire_date BETWEEN TO_DATE ('20060501', '... 阅读全文
摘要:
按sort排序,sort为空的在后面 select * from 表名 order by (case when sort is null or sort='' then 1 else 0 end),sort select t.*, t.rowid from hs_tr_goods_attach_re 阅读全文
摘要:
<deleteid="deleteCTQ" parameterType="java.lang.String"> DELETE FROM sqm_product_ctq_current where guid in <foreach item="idItem"collection="array"op 阅读全文