当前位置:Gxlcms > 数据库问题 > oracle中根据时间获取最新的一条数据

oracle中根据时间获取最新的一条数据

时间:2021-07-01 10:21:17 帮助过:1567人阅读

kd.CREATEUSERID as userid,kd.LOCATION,kd.createtime as location from KT_DEVICESTRACK kd where rownum=1 order by kd.createtime
  1. <span style="color: #0000ff">2、SELECT</span> <span style="color: #808080">*</span> <span style="color: #0000ff">FROM</span><span style="color: #000000"> (
  2. </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">
  3. ) </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   

人气教程排行