Count function giving duplicate record count

Other SQL Server Topics
1

I am trying to execute a join query with count function but i am getting duplicate record count also. How can i omit that duplicate record count and get exact value.

2

please provide sample data or a screen shot of what you are talking about?

3

image

4

In this exception count is the count function which i used.

5

Please post create table statement(s) and sample data in the form of inserts, what you've tried so far and the desired result.

6

Sorry i am not executing Create table, i am executing select query.

7

please provide source data for us to test with.

create table #pavan(field1 int, field2 varchar(50))

insert into #pavan
select 1, 'sample data' union
select 2, 'sample data2'
8

I you want more help please post the requested so people can help without guessing.