Untitled

 avatar
user_4802292
plain_text
a year ago
224 B
31
Indexable
Never
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