Wednesday, September 18, 2019

last row in oracle table in sql

select
  EMP_ID
from
  IT_INV_ISSUE_FORM
where
  rowid =(
    select
       max(rowid)
    from
       IT_INV_ISSUE_FORM)

No comments:

Post a Comment

 https://www.linkedin.com/pulse/building-real-time-database-monitoring-dashboard-oracle-khaleeq-tpwxf/