How to display always just the first value from the same values in a result table of an SQL query?

I have a select query, which returns many same ordered values in one column.

Looks like this:

But I like to display like this:

Thanks for any advice!

>Solution :

You can use lag window function,

select t.id, 
    case when lag([type]) over(order by id)=[type] then '' else [type] end [Type]
from t