sql question

[eyeseetee]

Hi I am trying to select distinct fields from a table. The problem is some of them are still duplicating even with the distinct function there. Why would this be? Does the distinct function not work with every query?

[Manas Bhardwaj]

First this is not a SQL Forum.

.netman wrote:

The problem is some of them are still duplicating even with the distinct function there. Why would this be?

Second you didn't provide your query.

.netman wrote:

Does the distinct function not work with every query?

It does. Definitely, there is some problem with your query or the way you are expecting the result.

Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.

[eyeseetee]

I needed to use group by clause which then helped eradicate the problem.

[AprNgp]

u r right, this happens ... u may try to use WHERE clause (if possible)...

Apurv

[metallica_rock10]

Please provide the query.

ASP.NET