使用SQL进行高级搜索

Question

我有这个表(tblStudent)在Sql Server:

<表类> Id 名称 年龄 PlaceOfBirthId CityId tbody><<tr>1N111232N219463N3113564陶瓷148115它们1327126N62125457N733978N8238719N915767110N1041133

你可以这样做:

select *
from tblstudent s
where exists (
select 1 from filter f 
where f.filterid = 1 and f.filtervalue = s.placeofbirth
) 
and exists (
select 1 from filter f 
where f.filterid = 2 and f.filtervalue = s.cityid
)