question

lsa avatar image
lsa asked

SQL server query to specify 3 conditions on same column in a table

I need help on writing condition I have a table with below table tblSampledata Title Value A 1800 A 1600 B 1672 B 1794 B 1672 B 1794 Condition i need help is : Value 1800 not allowed with Value (1672, 1794) if same Title Example : if 1672 or 1794 is used for Title B, then 1800 should not be used for Title B Thank You
sqlsq
1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

WRBI avatar image WRBI commented ·
Is this for use in a WHERE clause, check constraint or something else?
0 Likes 0 ·

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.