SQL Query - Conditions

[Manj]

Hi, 

I am not sure how to write a query for the below case, Pls help me out.

ID	description	values
M1	ab1	23
M1	ab2	54
M1	ab3	23
M2	ab1	67
M2	ab2	56
M2	ab3	91
M3	ab1	41
M3	ab2	53
M3	ab3	27
M3	ab4	41

Conditions: I need to pick the row when values are same for different description under similar ID, 

Example: Under ID (M1) , I have the description (ab1 and ab3) have same values (23), 

                  Similarly ID (M3) have same values 41 for descripttion ab1 and ab4. hence the result must be only Red texted in the table. 

 

Thanks In advance.

 

[Sherin]

You can try this query 

select column_name1,column_name2 ,column_name3 where column_name3  = 23 and Val=41;

i will this query is help for you

if you any query this query related then you ask me.