• SELECTTOP 100 (select count(*) from X) AS Total_Counts,

    *

    FROMX