Hi,
you have circled trans_Desc 182. if that means you want to select on this criteria...
you can do this as
SELECT * FROM LGR WHERE TRANS_DESC
in ( select Max(TRANS_DESC) from LGR )
it will display a group of records..
and if your purpose is something diff. then please explain little more about the purpose.