On Fri, 9 Jul 2004, Peter Westergaard wrote:
One idea that occurs to me, and it's a tradeoff from Torsten's idea (which
is to read the whole database, and parse out the unique rows), is to first
execute your SELECT DISTINCT distinct_col FROM table, and then walk
through that, and for each one
Lars,
One idea that occurs to me, and it's a tradeoff from Torsten's idea (which
is to read the whole database, and parse out the unique rows), is to first
execute your SELECT DISTINCT distinct_col FROM table, and then walk
through that, and for each one issue a SELECT * FROM table WHERE
I'm using PHP with mySQL since a long time.
But now I got a question:
I need to generate a SQL-Statement to fetch rows with one DISTINCT
criteria.
To make things clear: I don't want to fetch a single DISTINCT column, I
want
to fetch the whole row, where one column is DISTINCT.
Can
Lars Hilsebein [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Sorry, but it's not truly what I am searching for:
The result is not unique.
What I mean is: every entry in the distinct_col should only be delivered
once.
As it would happen when I do the query SELECT DISTINCT distinct_col