i want to select Distinct count(id) as activeusers from a table where useractive=1, but at the same time i want to select all the users example distinct Count(id) as totalusers regardless of activestate. How to achieve this in a SQL query please guide.