use master SELECT Serial, COUNT(Serial) AS [Count] FROM _Stat WHERE Value > 80-- chi so > 80 GROUP BY Serial HAVING ( COUNT(Serial) > 1 )-- so dong 80 > 1 order by [Count] desc select * from _Stat where serial = 1268182
