with CTE as
(
    select 
        bookid,
        ROW_NUMBER() OVER(PARTITION BY Location ORDER BY bookid DESC) as RowNum
    from MyTable
)

delete from MyTable
from MyTable as t
join CTE as c
    on c.bookid = t.bookid and c.RowNum > 1

DELETE FROM tn
FROM dbo.tablename tn
INNER JOIN (
    SELECT location, MAX(bookid) AS bookid
    FROM dbo.tablename
    GROUP BY location
) AS tn_max ON
    tn.location = tn_max.location AND
    tn.bookid < tn_max.bookid