if i have a table with entries like
1 2 342
1 3 532
1 4 555
1 7 222
2 1 333
2 2 332

now i want
1 4 555
2 1 333
to be displayed

how to do it

More information needed. What are you using to access the database? What format is the database in?

Whatever you are using, it is unlikely that you will be able to retrieve the two records you mention with a single query as there is no similarity between them. You will have to use two separate queries.

Stuart

Two separate queries are not needed. That's what OR is for. In a SQL type database it would go something like this (assuming the names of the columns are C1, C2, & C3):

SELECT * FROM table_name
WHERE (C1=1 AND C2=4 AND C3=555)
   OR (C1=2 AND C2=1 AND C3=333)

Ideally, though, each record would have a unique id so that you don't have to get that granular in the select statement.

Michael J