T-SQL question

Question

I have the following table:-
ID Name
01 AA
02 AB
01 AC

I need to get all the data where Name =’AA’ and corresponding all the IDs.
Say for example, ID (01) has Name =’AA’. ID (01) has also Name =’AC’. SO the out come would be:-

ID Name
01 AA
01 AC

How to get it? Any help would be highly appreciated.
Thanks

Answer 1

Hi chuckDM-9763

Do you have any updates？
Please remember to accept the answers if they helped. Your action would be helpful to other users who encounter the same issue and read this thread.
Thank you for understanding!

Echo

Answer 2

 select t1.ID,t1.Name from test t1
 where exists (select 1 from test t2
 where t1.id=t2.id and t2.name='AA')

Answer 3

Select t2.ID, t2.Name
From YourTableName t1
Inner Join YourTableName t2 On t1.ID = t2.ID
Where t1.Name = 'AA';

Tom

Answer 4

Please refer to ：

    create table test (ID int,Name char(15))  
    insert into test values  
    (01,'AA'),  
    (02,'AB'),  
    (01,'AC')  
  
select * from test  
where name='AA' or id=(select id from test where name='AA')  
  
drop table test   

If you have any question, please feel free to let me know.
If the response is helpful, please click "Accept Answer" and upvote it.

Best Regards
Echo

---

If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 5

This should work for you:

SELECT *
FROM yourTable AS T
WHERE T.ID IN (SELECT SUB.ID FROM yourTable AS SUB WHERE SUB.Name = 'AA')