select * from TAB where 时间 BETWEEN to_date('2011-02-01 22:03:40','yyyy-mm-dd hh24:mi:ss') and to_date('2011-12-02 22:03:40','yyyy-mm-dd hh24:mi:ss') 或者: select * from TAB where to_char(时间,'yyyy-MM-dd hh24:mi:ss') between '2011-02-01 22:03:40'and '201
1.inner join ,left join 与 right join (from 百度知道) 例表aaid adate1 a12 a23 a3表bbid bdate1 b12 b24 b4 (1)两个表a,b相连接,要取出id相同的字段 select * from a inner join b on a.aid = b.bid 此时的取出的是:1 a1 b12 a2 b2 (2)left join 指:select * from a left jo