select count and other records in one single query

Viewed 63408

I have the following query

select main_cat_name,cat_url from mf_main order by main_cat_name

This returns whole data of my table.Now i want to have count of the total rows of this table.I can do it using another query but how can i use them in one single query???

I want two data ONE :- the rows of the table TWO:- the count how can i have that in one single query

I tried this but it gives correct count but displays only first row of the table :

select count(cat_id),main_cat_name,cat_url from mf_main order by main_cat_name
5 Answers
Related