SQL Query

I am trying to query a database to to filter the database to list each product by the maximum line number and include other column info. Example database would be:

ID LineNo Prod Desc Price
100 12 Widgets Blah $10.99
100 13 Widgets Bong $12.99
100 14 Widgets Poof $11.99
101 12 Gadgets Blink $8.99
101 13 Gadgets Boof $7.99
101 16 Gadgets Bonk $6.99