SELECT a.* from dbo.book a , (SELECT max(id) as id from dbo.book group by title,isbn,author_id ,page_count )b where a.id = b.id
10-10
2639
05-26
1026
07-27
2096
SELECT a.* from dbo.book a , (SELECT max(id) as id from dbo.book group by title,isbn,author_id ,page_count )b where a.id = b.id