Help on whriting a SQL Script / statement

[shubho12003]

Try this:

select DataAndtime , Value , Tagname from #temp1
where Value in (select MAX(Value) from #temp1 group by Tagname)