O God Why am getting the repeated values again and again pls some 1 help me
My Prob:
step1:
I used this query to get an unique value from an database and i got exact result
select DISTINCT fnlwgt from Dataset;
Step2:
I used this query to get entire records which must matches the unique value using join query here is my code
da = new SqlDataAdapter("SELECT rule1.Age, rule1.workclass, rule1.fnlwgt, rule1.education, rule1.maritalstatus FROM rule1 INNER JOIN probablity ON rule1.fnlwgt = probablity.fnlwgt", cn.con);
Am geting the result as
53 Self-emp-inc 100029 Doctorate Married-civ-spouse
53 Self-emp-inc 100029 Doctorate Married-civ-spouse
53 Self-emp-inc 100029 Doctorate Married-civ-spouse
53 Self-emp-inc 100029 Doctorate Married-civ-spouse
53 Self-emp-inc 100029 Doctorate Married-civ-spouse
53 Self-emp-inc 100029 Doctorate Married-civ-spouse
53 Self-emp-inc 100029 Doctorate Married-civ-spouse
53 Self-emp-inc 100029 Doctorate Married-civ-spouse
53 Self-emp-inc 100029 Doctorate Married-civ-spouse
28 Private 100219 HS-grad Never-married
28 Private 100219 HS-grad Never-married
28 Private 100219 HS-grad Never-married
28 Private 100219 HS-grad Never-married
28 Private 100219 HS-grad Never-married
28 Private 100219 HS-grad Never-married
28 Private 100219 HS-grad Never-married
55 Self-emp-not-inc 100569 HS-grad Separated
55 Self-emp-not-inc 100569 HS-grad Separated
55 Self-emp-not-inc 100569 HS-grad Separated
55 Self-emp-not-inc 100569 HS-grad Separated
55 Self-emp-not-inc 100569 HS-grad Separated
55 Self-emp-not-inc 100569 HS-grad Separated
55 Self-emp-not-inc 100569 HS-grad Separated
55 Self-emp-not-inc 100569 HS-grad Separated
55 Self-emp-not-inc 100569 HS-grad Separated
55 Self-emp-not-inc 100569 HS-grad Separated
As such i have nearly 31225 records
But the expected Result is
53 Self-emp-inc 100029 Doctorate Married-civ-spouse
28 Private 100219 HS-grad Never-married
55 Self-emp-not-inc 100569 HS-grad Separated
what should i do to get particular result pls some 1 help me