Returning the number of rows and the details in the same result set?

[tbtcust]

I would like to select detailed information from a table. As part of the result set I would also like the total number of rows in the result set. See example below.

Is this possible to do this in a single pass?

Desired result set:
Table_1.Column_1 Table_1.Column_2 Table_1.Column_3 5 Rows Returned
Table_1.Column_1 Table_1.Column_2 Table_1.Column_3 5 Rows Returned
Table_1.Column_1 Table_1.Column_2 Table_1.Column_3 5 Rows Returned
Table_1.Column_1 Table_1.Column_2 Table_1.Column_3 5 Rows Returned
Table_1.Column_1 Table_1.Column_2 Table_1.Column_3 5 Rows Returned


Thanks in advance for any help.

 

[martynh]

My best suggestion (and's not elegant) is:

select t.*, counter.num
from sometable t
, table (select count(*) as num from sometable) as counter

Performance shouldn't be bad as the count part should resolve first as an index only access, but I'd comment my code to explain what I'm doing here!

 

[tbtcust]

Thanks martynh. Your example works.