Count of total data with out using Count function
select sum(1) as count from tablename;
Count of total data using Count function
select count(*) from tablename;
Count of total data with out using Count function
select sum(1) as count from tablename;
Count of total data using Count function
select count(*) from tablename;