how to get value by passing multiples value in T-Sql ?
Hi,
I have a table which has 2 columns namely PlanId and RiderId in below format-
Query is- I want pass multiple riderid and i want to get PlanId on the base of multiple RiderId.
In this case i will pass 327,329,330,326,355.
But 327 available in 2 times in planId column having 356349 and 356347 but here i want only one PlanId which is 356349 , because it hold combination values. How i accomplish this.
PlanId RiderId
356348 330
356348 355
356348 327
356348 329
356349 327
356349 329
356349 330
356349 326
356349 355