I have a table that includes duplicate values in one of the fields(housekey)
I want to be able to query distinct records from this table, I need all the fileds and not just only one field. How can I accomplish this?
select Distinct Huse_Hld_Key, T.*
from TempTbl T
only gives me Hust_hld_key