sql server - SQL Script select last column in table

Question

Data table

I want to select last

Answer 1

You should give data in text not in image. Anyways Try this:

select *
from data_table
qualify() row_number()over(partition by computerName order by timestamp desc)=1

or this:

select *
from data_table
where (computerName,timestamp)
in 
(select computerName,max(timestamp)
from data_table
group by 1)