如何使用分组获取（选择）具有特定列的最大值的行

I have a table with duplicate data of books issued by students. Students can issue books(one book at a time in this case). SQL for the table trn_books:I have a table with duplicate data of books iss