Re: Duplicate values only once [message #375021] |
Thu, 19 July 2001 06:10 |
Siddharth Bahri
Messages: 18 Registered: March 2001
|
Junior Member |
|
|
Hi Kavitha,
Thanx for the quick response.
I think there is some misunderstanding. I have only one table with two fields f1 and f2. I want all rows from table where f2's value is not repeated.
But never mind. I have got the answer now. The query I used is
SELECT e1.f1, e1.f2
FROM table_name e1
where
AND e1.f1 =
(select max(f1) from table_name where f2=e1.f2)
group by e1.f2,e1.f1
This query is ok for me.
Thanx again
Siddharth
|
|
|