Get Row Count including Column Values in SQL Server

In this blog we will learn about how to Get Row Count including Column Values in SQL Server.

Some time you need to show Total number of records and column value from a SQL Server table.

Below is my Data Table from I am reading records:


Image 1: Reading Record

Now Select Column from this table.


Image 2: Select Column

Now I want to show one more column which will show Total Number of records in this table. So First below thought in our mind come:

SELECT COUNT(*) AS TotalRecords, EMPLOYEE_ID,NAME,EMAIL,MOBILE,
COUNTRY FROM EMPLOYEETEAM

If you use avobe query then you will get below error message:


Image 3: Error Messege

So the right Query is

SELECT COUNT(*) OVER (PARTITION BY 1) AS TotalRecords, EMPLOYEE_ID, NAME,
EMAIL, MOBILE, COUNTRY FROM EMPLOYEETEAM

Image 4: Output