Using SQL Server 2012 function in use
select * from
(
select
*,CUME_DIST () OVER (PARTITION BY marker ORDER BY val)-
RANK() OVER (PARTITION BY marker ORDER BY val ) AS PctRank
from
#Temp t
)T1 where PctRank=0
--------------------------------------------------------------------------------------------------
I am just an another naive wannabe DBA trying to learn SQL Server