Hi All,

How can i write a query to count the number of records from a derived table. the derived table is a union of two table.

select msisdn from enrollOffer union DISTINCT select msisdn from enrollHistory