| empid ename course |
| 1104 abc btech |
1105 cde java
| 11 05 cde inter | |||
| 1106 efg dotnet |
how to get the total number of original records
i have the table like shown below.how to get the total number of original records in the table using sql
1104 abc mba
1105 cde java
1106 efg sql
1105 cde java
Swapna ChandaPosted Jan 21, 2015, 10:55 PM
Manish Kumar ChoudharyPosted Jan 21, 2015, 10:41 PM
Create TABLE #LocalTempTable(
empid int,
ename varchar(50),
course varchar(150))
insert into #LocalTempTable values ( 1104, 'abc','xyz');
insert into #LocalTempTable values ( 1104, 'abc','xyz');
insert into #LocalTempTable values ( 1104, 'abc','xyz');
insert into #LocalTempTable values ( 1105, 'abc','xyz');
insert into #LocalTempTable values ( 1106, 'abc','xyz');
insert into #LocalTempTable values ( 1105, 'abc','xyz');
insert into #LocalTempTable values ( 1106, 'abc','xyz');
insert into #LocalTempTable values ( 1107, 'abc','xyz');
insert into #LocalTempTable values ( 1108, 'abc','xyz');
SELECT COUNT(DISTINCT empid) FROM #LocalTempTable;