Find out the value of column A with a specified value in column B.

Create   Table Test (name Varchar ( 20 ) Not   Null , Holobby Varchar ( 20 ) Not   Null  );  Insert   Into Test Values ('  Adam  ' , '  Basketball  '  );  Insert   Into Test Values ( '  Bill  ' , '  Basketball  ' );  Insert   Into Test Values ( '  Bill  ' , '  Football  '  );  Insert   Into Test Values ( '  Cyper ' , '  Basketball  '  );  Insert   Into Test Values ( '  Cyper  ' , '  Badminton  '  );  Insert  Into Test Values ( '  David  ' , '  Basketball  '  );  Insert   Into Test Values ( '  David  ' , ' Badminton  '  );  Insert   Into Test Values ( '  David  ' , '  Table Tennis  ' );

Use SQL statements to find out who will play basketball and badminton and find out the name-Hoby combination.

SelectName, holobbyFromTestWhereHolobbyIn('Basketball','Badminton')Group ByNameHaving Count(Name)= 2
 

 

Address: http://www.iteye.com/topic/1122917