Stop repeat entries

[Damien]

Can you stop pulling out exactly the same data from a database, for
example, if you had 2 entries which had the name Chris, it would only
print Chris once?

[Joshua Ghiloni]

Damien wrote:

Can you stop pulling out exactly the same data from a database, for
example, if you had 2 entries which had the name Chris, it would only
print Chris once?

You could use SQL's DISTINCT keyword, but that would only work if every
row in your resultset would be a match.

for instance, given the table

fname | lname
------+------
Chris | Smith
Chris | Jones

SELECT DISTINCT(fname) FROM tblName WHERE fname='Chris' would work, where

SELECT DISTINCT(*) FROM tblName WHERE fname='Chris' wouldn't.

You might be able to do it with some nasty JOINs but those are evil and
kill your performance.

[DjDrakk]

Actualy, if you are using SQL, I would use a LIMIT command as follows

SELECT fname FROM table WHERE fname = Chris LIMIT 1;

--
Your GP or your HP!
Warren Butt

"Joshua Ghiloni" <jd***@SPAM.ME.AND.DIE.cwru.edu> wrote in message
news:bg**********@eeyore.INS.cwru.edu...

Damien wrote:

Can you stop pulling out exactly the same data from a database, for
example, if you had 2 entries which had the name Chris, it would only
print Chris once?

You could use SQL's DISTINCT keyword, but that would only work if every
row in your resultset would be a match.

for instance, given the table

fname | lname
------+------
Chris | Smith
Chris | Jones

SELECT DISTINCT(fname) FROM tblName WHERE fname='Chris' would work, where

SELECT DISTINCT(*) FROM tblName WHERE fname='Chris' wouldn't.

You might be able to do it with some nasty JOINs but those are evil and
kill your performance.

[Joshua Ghiloni]

Joshua Ghiloni wrote:

Damien wrote:

Can you stop pulling out exactly the same data from a database, for
example, if you had 2 entries which had the name Chris, it would only
print Chris once?

You could use SQL's DISTINCT keyword, but that would only work if every
row in your resultset would be a match.

for instance, given the table

fname | lname
------+------
Chris | Smith
Chris | Jones

SELECT DISTINCT(fname) FROM tblName WHERE fname='Chris' would work, where

SELECT DISTINCT(*) FROM tblName WHERE fname='Chris' wouldn't.

You might be able to do it with some nasty JOINs but those are evil and
kill your performance.

Yes forget I said all this. I've been at work too long today, and I'm
tired :)