SQL Server 2017

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

select *
into mytable
from (select 'X' as c1) x
cross apply (values(1),(2),(3),(4),(5),(6),(7),(8),(9),(10))as y(Y)
10 rows affected

select * from mytable


c1
Y


X
1

X
2

X
3

X
4

X
5

X
6

X
7

X
8

X
9

X
10


select * from
(
select *, COUNT(*) OVER() CT
from mytable
where c1 = 'X'
) sub
where CT > 10


c1
Y
CT