select distinct 1

[camy123]

Hi guys
can you help im running a distinct against a column but its still bringing out duplicates ne idea
for example when i run

select disticnt name from table it works fine

but whe i run

select distinct name, creationdate from table
it brings out duplicates

ne idea
Please

 

[gradley]

That is because you are asking for a distinct combination of Name and CreationDate. You obviously have multiple CreationDates for the Name field. What is it you are trying to achieve here.

 

[camy123]

I just want all the data where name is distinct thats all

 

[gradley]

So you are looking for unique "Name" records only?

If so, try this

Select Name, CreationDate
From Table
Where Name IN (Select Name from Table Group by Name Having Count(*) = 1)

 

[camy123]

your a star cheers mate ,
bingo...... if we could send online prings i would send u one.
cheers again
cam

 

[camy123]

i meant pints