Number of rows returned as column in query

[tshad]

I know there is a way to put the number of rows returned as a column (not count() which would be an aggregate) in my select statement but can't remember what it is.

Something like:

SELECT Num_rows_returned, Name, address
FROM USERS

Where Num_rows_returned would be the number of rows returned. If it returned 10 rows, that columns would be 10 for all the rows.

Thanks,

Tom

 

[markros]

Try (SQL 2005+):

SELECT count(*) over() as Num_rows_returned, Name, address
FROM USERS

PluralSight Learning Library