SQL Query for select all rows, rows count from a table

Question

0.00/5 (No votes)

See more:

SQL-Server

I have a table T1, Now I need to return whole rows and rows count in a single query

Posted 25-Mar-11 1:54am

vipinsethumadhavan

Add a Solution

Comments

Wendelius 25-Mar-11 14:28pm

If the issue isn't solved, could you add a little example for the original data and how you want the output. Do you actually want a running total?

3 solutions

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Mahendra.p25 · Answer 1 · 2011-03-25T02:01:00

Solution 1

try this

select column1,column2,@@ROWCOUNT as rows from table

it will return all columns ,row count in each rows

Posted 25-Mar-11 2:01am

Mahendra.p25

Updated 25-Mar-11 2:30am

v2

Comments

m@dhu 25-Mar-11 8:30am

Use pre tags to wrap the code for better readability.

vipinsethumadhavan 25-Mar-11 8:32am

I got a error as suquery returns more than one rows.
I have a query ,which got result as
select '' as count,col1,col2 from t1 union
select count(*) as count,'','';No problem
But issue is that first query has order clause.But Order clause can't use here

Costica U · Answer 2 · 2011-03-25T18:10:00

Solution 2

For Sql 2005 and up try this

SQL

select  *,
        rowcnt = count(*) over()
from    MyTable

Posted 25-Mar-11 18:10pm

Costica U

Abhinav S · Answer 3 · 2011-03-25T18:23:00

Solution 3

select *, (select count(*) from table) from table

Not most optimal but works!

Posted 25-Mar-11 18:23pm

Abhinav S

SQL Query for select all rows, rows count from a table

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0

SQL Query for select all rows, rows count from a table

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0

Existing Members

...or Join us