Select * From Tb_DataHouse Where id in (Select Min(id) From Tb_DataHouse Group By Tb_DataHouse_Id)
select * from dbo.Tb_DataHouse inner join dbo.Tb_HousePic on dbo.Tb_DataHouse.id=dbo.Tb_HousePic.Tb_DataHouse_id where dbo.Tb_DataHouse.id in(select min(Tb_DataHouse_id) from dbo.Tb_HousePic GROUP BY Tb_DataHouse_id)我这样写还是现实所有的 并且会查询6条记录
select * from dbo.Tb_DataHouse inner join dbo.Tb_HousePic on dbo.Tb_DataHouse.id=dbo.Tb_HousePic.Tb_DataHouse_id where dbo.Tb_DataHouse.id in(select min(Tb_DataHouse_id) from dbo.Tb_DataHouse GROUP BY Tb_DataHouse_id)
select * from dbo.Tb_DataHouse inner join dbo.Tb_HousePic on dbo.Tb_DataHouse.id=dbo.Tb_HousePic.Tb_DataHouse_id where dbo.Tb_DataHouse.id in(select min(id) from dbo.Tb_DataHouse GROUP BY Tb_DataHouse_id)
on dbo.Tb_DataHouse.id=dbo.Tb_HousePic.Tb_DataHouse_id where dbo.Tb_DataHouse.id
in(select min(Tb_DataHouse_id) from dbo.Tb_HousePic GROUP BY Tb_DataHouse_id)我这样写还是现实所有的 并且会查询6条记录
on dbo.Tb_DataHouse.id=dbo.Tb_HousePic.Tb_DataHouse_id where dbo.Tb_DataHouse.id
in(select min(Tb_DataHouse_id) from dbo.Tb_DataHouse GROUP BY Tb_DataHouse_id)
on dbo.Tb_DataHouse.id=dbo.Tb_HousePic.Tb_DataHouse_id where dbo.Tb_DataHouse.id
in(select min(id) from dbo.Tb_DataHouse GROUP BY Tb_DataHouse_id)