Hi All,
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?
my code

select Distinct Huse_Hld_Key, T.*
from TempTbl T

only gives me Hust_hld_key

Thanks