时间:2021-07-01 10:21:17 帮助过:1567人阅读
- <span style="color: #0000ff">2、SELECT</span> <span style="color: #808080">*</span> <span style="color: #0000ff">FROM</span><span style="color: #000000"> (
- </span><span style="color: #0000ff">SELECT</span> <span style="color: #808080">*</span>,ROWNUM rn <span style="color: #0000ff">FROM</span> t <span style="color: #0000ff">ORDER</span> <span style="color: #0000ff">BY</span> date_col <span style="color: #0000ff">DESC</span><span style="color: #000000">
- ) </span><span style="color: #0000ff">WHERE</span> rn <span style="color: #808080">=</span> <span style="color: #800000; font-weight: bold">1</span>
oracle中根据时间获取最新的一条数据
标签:acl weight dev style ati str bsp 时间 des