how to select unique combination

[scorpioy]

I want to find unique combination of two fields in a table, I tried either this:

SELECT distinct(field1), distinct(field2)
FROM someTable

or this

SELECT distinct(field1, field2)
FROM someTable

but neither of them works. Can someone tell me the correct syntax?
Thanks.

[inerte]

SELECT DISTINCT field1, field2 FROM someTable

[scorpioy]

Thanks for the reply.

If I want to delete all the duplicate record from someTable, which is the complement of
SELECT DISTINCT field1, field2 FROM someTable

what sql should it be? Thanks.

[LoganK]

Don't know what the "one-time" SQL statement is, but what you could do is the opposite of "SELECT DISTING field1, field2 FROM table", get the IDs of all of those (because they're not distinct, so they're obviously duplicate), and then go in a loop executing "DELETE FROM table WHERE field1=$id" or something like that.