Simple SQL Problem

[trueadvantage]

I have 1 confusion about query.

I have one data sheet which has students name and their marks.

some of the student has got same marks. I want to find out their names.

e.g.: - A 50
B 40
C 50
D 40
E 60
F 60

I want to make query for this. which will help me to find out the duplicates from that sheet means if i put "50" in a particular field the result should display as "A" "C" (bcoz "A" , "C" has got same marks.)

Please let me know if you have any suggestion or solution

Thanks,

[NeoPa]

Please be careful where you post your questions. I found this appended to an unrelated HowTo article (Accessing Field Values in Recordsets).

Admin.

[NeoPa]

In response to your question, you would use SQL similar to the following (you provide little information so I had to make up my own table and field names):

SELECT [StudentName], [Mark]
FROM [tblStudent]
WHERE [Mark] In(SELECT [Mark]
                FROM [tblStudent]
                GROUP BY [Mark]
                HAVING Count(*)>1)

[trueadvantage]

In response to your question, you would use SQL similar to the following (you provide little information so I had to make up my own table and field names):

SELECT [StudentName], [Mark]
FROM [tblStudent]
WHERE [Mark] In(SELECT [Mark]
                FROM [tblStudent]
                GROUP BY [Mark]
                HAVING Count(*)>1)

Hi...

First I Apologize for putting question in Howtos. and Thanks a lot for help. I will try with this query. If again i meet with same problem I will let you know all details about the work which im doin.

Thanks a lot

[NeoPa]

Not to worry too much.
It's early days and we all make mistakes at the start.

Welcome to TheScripts :)

[NeoPa]

Ah, I just reminded myself of the whole story with the double-post and all.
Again - no worries. I guess the first post got lost to you as it was posted in the HowTo by mistake.

Click on Subscribed (in blue at top) to find any threads you've been involved in.

[NeoPa]

This thread now continues in another one (Query Problem).