How can I get peer column values if parent id matches. In the below example, I'll give subcat_id as 42 and based on cat_id(6) it should give me 41 and 43.
cat_id----subcat_id---name
===========================
5---------40----------ABC
6---------41----------DEF
6---------42----------GHI
6---------43----------JKL
Thanks.