SQL select all query to return only MAX seqno : Below query returns multiple rows as you can see in the image below.


I want to know how to return only one row with MAX seqno on it. Appreciate you help. 

`SELECT * 
FROM dbo.SALESORD_HDR HD JOIN dbo.SALESORDHIST AS HI ON HD.SEQNO = HI.HEADER_SOURCE_SEQ
AND hi.FILEURL <> '' AND HI.EVENT_TYPE='D' `

[![enter image description here][1]][1]


  [1]: https://i.stack.imgur.com/KYFMk.jpg