Count and select

If I select only 5 rows by limit can I in some way know how many rows that are in the table also with only one query?

Ie.

select * from table where id=1 limit 5
+
count rows where id=1

Can this be done in one query?

Nope.

It will take two different queries to get both results.

You might be able to use subselects or a union to do this as well. If you're using a version of a database that supports those things.

select aid,bid,(select count(*) from accounts) as total from accounts limit 5;

Works in pgsql 7.4beta1
as does:

select from (select count(),0 from accounts) as a union (select aid,bid from accounts limit 5);