distinct function in mysql

Anon

Hi!

I'd like to use DISTINCT function in mysql.
Everything works fine when use it for one field like:

select distinct(fieldname) from table

but what if i'd like to have id's too for these fieldname rows!
something like:

select distinct(fieldname),id from table
but this doesn't work!

anyone?

Anon

Have you try "SELECT DISTINCT(fieldname,id) FROM table" ??

Anon

Yes i have but Mysql error is the result.

Anon

SELECT DISTINCT City, ID from listings

Anon

comme ca:

SELECT DISTINCT fieldname, id FROM table

voila !

Anon

I was looking for a SQL commands like this

my problem is that I have a table, from witch I wish to have all distinct "user_ip", but togeter with the users_ip, I would also like to have the time (not distinct)

so a SQL like
SELECT DISTINCT user_ip,time FROM table

would give me a result where all distinct user_ip AND distinct time is in.

witch mean I will also get thise 2

ip | time |
-----------------------|

12.34.56.78 | 12:00 |

12.34.56.78 | 14:00 |

.
.

I only wan the DISTINCT to work on the first row (user_ip), and it should be the last one of them (14:00)

I guess something like this, but it does not work...

SELECT DISTINCT (user_ip) time FROM table ORDER BY time

how do I do that - anyone knows ?

Anon

I found out elswhere in this forum

I using a SQL lke this, and it seams to work as I wish

SELECT FIELD1,MAX(FIELD2) AS MAXFIELD2
FROM TAB
GROUP BY FIELD1
ORDER BY MAXFIELD2 DESC;