query to get a unique pair of details from db

rekchris

I have a table MyTable with multiple fields.
eg : ip, gw,id where id is the primary key
I need unique ip,gw pairs
eg:
ip gw id
1.1 a 1
2.1 b 2
3.1 c 3
1.1 a 4

I need to eliminate duplicate pairs ie 1.1 a
I am not able to build such a query

Atli

Moving this thread to the MySQL Forums.
Please try to refrain from posting questions in the Article section.

MODERATOR

Atli

Hi, and welcom to TSDN.

Do you need your ID column?
If not you could make the other two fields act as Primary Key. Then they would not be able to accept duplicate values.

E.g:

Expand|Select|Wrap|Line Numbers

 
CREATE TABLE myTable

(

  colA VARCHAR(255) NOT NULL,

  colB INT NOT NULL,

  Primary Key(colA, colB)

)

query to get a unique pair of details from db

re: query to get a unique pair of details from db

re: query to get a unique pair of details from db

Similar MySQL Database bytes

/bytes/development

/bytes/it

/bytes/about