vendredi 22 juillet 2016

is there any key word like "Only IN" keyword in sql server

something like - Select * from RoomMemberTable where RoomMemberId "ONLY IN" ('RM1','RM3') My table structure -

RoomId RoomMemberId R1 RM1 R1 RM2 R1 RM3 R2 Rm1 R2 RM2 R3 RM1 R3 RM3

I need to get rows which contains only these room members. Here i don't need such entries where any other member except RM1 and RM3 presents.

Aucun commentaire:

Enregistrer un commentaire