CodePudding user response:
How to do? It's too difficultCodePudding user response:
Select * from personal information where blood type in
Personal information (select type models from group by blood type having a count (blood type) & gt;
=2)
CodePudding user response:
select * from tableName as a
Where the exists (
Select 1 from tableName as b
Where a student id! Blood type==b. student id and a. b. blood type
)
Order by a. blood type