0 Replies - 642 Views - Last Post: 17 March 2015 - 05:31 AM

#1 DarenR  Icon User is offline

  • D.I.C Lover

Reputation: 593
  • View blog
  • Posts: 3,823
  • Joined: 12-January 10

why does oracle hate my FROM

Posted 17 March 2015 - 05:31 AM

(select * from (select *, row_number()
 over (partition by bridge_gd order by inspdate, createdatetime desc) rn from inspevnt) inspevnt2 where rn = 1) inspevnt
    on inspevnt.bridge_gd = bridge.bridge_gd 



error

ORA-00923: FROM keyword not found where expected
00923. 00000 -  "FROM keyword not found where expected"
*Cause:    
*Action:
Error at Line: 38 Column: 46





if i remove the above from my pretty big query then it runs however i need the above to limit the returns. Can you see anything wrong with the query?

Is This A Good Question/Topic? 0
  • +

Page 1 of 1