Select a.TOTAL,b.SUBTOTAL
From (SELECT COUNT(*) AS TOTAL FROM TABLE)a inner join
(SELECT COUNT(*) AS SUBTOTAL FROM TABLE WHERE RELET=1 )b On 1=1
From (SELECT COUNT(*) AS TOTAL FROM TABLE)a inner join
(SELECT COUNT(*) AS SUBTOTAL FROM TABLE WHERE RELET=1 )b On 1=1
From (SELECT COUNT(*) AS TOTAL FROM TABLE)a join
(SELECT COUNT(*) AS SUBTOTAL FROM TABLE WHERE RELET=1 )b On 1=1
declare @a int,@b int
select @a=count(*) from TABLE
select @b=count(*) from TABLE
where relet=1
select @a TOTAL,@b SUBTOTAL
SUBTOTAL = SUM(CASE RELET WHEN 1 THEN 1 ELSE 0 END)
FROM TABLE