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.
please provide sample data or a screen shot of what you are talking about?
In this exception count is the count function which i used.
Please post create table statement(s) and sample data in the form of inserts, what you've tried so far and the desired result.
Sorry i am not executing Create table, i am executing select query.
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'
I you want more help please post the requested so people can help without guessing.