DISTINCT Values

Question

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

SQLZ SSChampion Points: 12872 More actions · Answer 1

Hi Dave,

Try this:

Hope that helps,

finlay SSC Enthusiast Points: 102 More actions · Answer 2

Hi Dave, perhaps you mean just the unique rows, in that case try

select g1,g2,g3,g4

from mytable

group by g1,g2,g3,g4

having count(*)=1;

David Burrows SSC Guru Points: 65142 More actions · Answer 3

SELECT DISTINCT G1,G2,G3,G4

FROM

WHERE (G1 <> G2 AND G1 <> G3 AND G1 <> G4)

AND (G2 <> G3 AND G2 <> G4)

AND (G3 <> G4)

Far away is close at hand in the images of elsewhere.
Anon.

DAve Broomhead Old Hand Points: 301 More actions · Answer 4

Hi, All

Just wanted to thank everyone for their help.

All the Best

Dave