how to get the total number of original records

Question

i have the table like shown below.how to get the total number of original records in the table using sql

empid ename course

1104 abc btech

1104 abc mba

1105 cde java

11 05 cde inter

1106 efg dotnet

1106 efg sql

Swapna Chanda · Answer

Thankq

Manish Kumar Choudhary · Answer

Hi Swapna Chanda  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 ;