clear markdown compare help donate or buy diddy dollings comments/suggestions/bugs a leap of faith? bible365
clear markdown donate comments/suggestions/bugs a leap of faith? bible365 diddy dollings
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 818545 fiddles created (9195 in the last week).

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
 hidden batch(es)


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
 hidden batch(es)


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