Delete only one item from table with multiple similar items

pendialek

New Member
I want to know, if I can perform such operation. I have following data arrangement in table:\[code\]id SessionId P_Name P_TypeId1 abc XYZ 52 abc XYZ 53 abc XYZ 54 abc XYZ 55 abc XYZ 56 abc XYZ 57 abc XYZ 5 8 abc XYZ 5\[/code\]Here I have 8 similar items, but have unique Ids.Condition: From frontend i will pass \[code\][P_TypeId] = 5\[/code\] and the query will then remove only one item from the table using a delete statement. Is this possible?
 
Back
Top