Take the 2-minute tour ×  I have table schem as'  Attribute_name
attribute_value  Attr_id uniquey_keyId   tag           A
111        1   price         113             111        2
product       B               111        3   value         115
111        4  I need to select attribute_value when
attribute_name = tag for all where attribute_value = 115 for
each Attr_id;  Output should be" A  This is the case where we
have multiple rows for the same id and spread across for
different values.  share|improve this question What have you
tried? –  Kundan Singh Chouhan Aug 16 '12 at 17:47 Hi, and
welcome to Stack Overflow. With questions like this it's often a
lot better if you also post the result-set you want. This means
that people have something to work to. It's polite if you post
the methods you attempted when trying to solve your problem.
This provides an indication of your thinking and helps others to
hep. It also proves that you have attempted something for
yourself and are not just