my English not enough to tell my problem. I am explaining with a SQL...



Content of "News" table:


title abstract
______ __________

a aa
b bb
c cc
d dd
e ee
f ff


SQL:

select
count(tblNews.*) as COUNT, tblNews.*
from
(
select * from News tblNews
)


Result (must be) :

COUNT title abstract
_____ ______ __________
6 a aa
6 b bb
6 c cc
6 d dd
6 e ee
6 f ff




this SQL giving error. Is there any alternative solution with one SQL?