selects columns from a table with the distinct operator

Question

Hi,team!

I want to selects multiple columns from a table with the distinct operator on one column only.
I am trying to select all the Type with their corresponding tb_ID.

I have tried:
Select Distinct(type), tb_ID FROM tbl
-Returns all results, not just distinct

Select Type, tb_ID FROM tbl Group By Type--wrong

Could you help me!Thank you for your time!

Answer 1

Hi,@SPWGUT

If I understand you correctly, I think you should use max() or min() aggregation function for tb_ID, try this solution:

select Type,Tb_ID  from tbl   
where tb_ID in (  
      Select max(tbl_ID) FROM tbl   
      group by Type  
)  

Bert Zhou

Answer 2

distinct operator on one column only.

That's not possible and don't make sense; which result would you expect here.

And at all, that's to less on information.
Please post table design as DDL, some sample data as DML statement and the expected result.