You can write this query but this query adds total count in every raw.

select 'fields', COUNT(*) OVER() as total_count
from table_name where conditions limit 10;