如何让in/exists 子查询(半连接)作为驱动表?
摘要:一哥们问我,怎么才能让子查询作为驱动表? SQL如下: select rowid rid from its_car_pass7 v where 1 = 1 and pass_datetime >= to_date('2013-07-06 :17:46:04', 'yy...
阅读全文
posted @ 2013-08-29 19:29
posted @ 2013-08-29 19:29
posted @ 2013-08-28 09:45
posted @ 2013-08-27 15:14
posted @ 2013-08-04 12:51
posted @ 2013-08-04 10:57
posted @ 2013-08-03 01:15