5 months ago

WhereIn with only one value

Posted 5 months ago by arctushar

WhereIn with only one value for all item

For Example

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

Please sign in or create an account to participate in this conversation.