Jump to content

SQL Query - Conditions


Recommended Posts


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.


Link to comment
Share on other sites

  • 4 weeks later...

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...