WhereIn with only one value for all item
In a table there are id, cost and item_id field.
For same item_id there are multiple id.
Now I want that pick row where item_id are 2,6,9 and for all item_id it will pick only last id for the specific item_id
so result will be Cost of 2, cost of 6 and cost of 9 based on latest id.
How Can I do that