Select TOP 1 in Sybase RRS feed

  • Question

  • I'm stuck with a query in Sybase. I'm getting this error : Error:156 at Line:2 Message:Incorrect syntax near the keyword 'TOP'.

    update  SUPPLIER_LOC_HDR
    set facility_code = ISNULL((select TOP 1 federal_control_num from SUPPLIER_LOC_DTL d where d.location_code = h.location_code) ,'')
    from SUPPLIER_LOC_HDR  h

    Any help??

    Thank youuuuu

    Thursday, June 16, 2011 12:25 PM


All replies