Comments by Member 13867163 (Top 12 by date)

this is working fine but is there any other solution for the above.
because if it is two columns then no problem, many columns takes much time for on conditions..

Great..
Thank you
this works fine

If I take Sno=1 then I get unique records ignoring duplicates

If I take Sno>1 then I get the records which having duplicates (in this case, A will come because it is having duplicates)

But what is needed is I want to get A name with how many times it is repeated like below.
Sno Sname Marks
1 A 10
2 A 10
remaining records dont want.

No this query producing unique records. But I want the result as below.
1 A 10
2 A 10
This should be my result
pls suggest

No what I mean to say is I have 3 ids are there in table1 I am joining with table 2
row by row base 3 ids in table1 is joined to table2 as below.

First id 1 having matches found 3 ids in table2 so the records are 3 rows.
second id 1 having match found 3 ids in table2 so the records are 3 rows
third id 1 having match found 3 ids in table2 so the records are 3 rows

So totol is 9 records.
But why it is giving 8 records.

Please suggest

Exactly. So my doubt is in First Table I have 3 Ids and in second table I have 3 Ids.
So 3X3=9 records should come. But while executing the query I am getting 8 records.

Hi,

Thank you for your reply.
My doubt here is the inner join result is giving 8 records as per my query.
my doubt is as per row by row joining it should be 9 records i think. why 8 records are given. any logic internally.

Please suggest