Home » RDBMS Server » Server Administration » Re: Duplicate values only once
Re: Duplicate values only once [message #375054] Sun, 22 July 2001 18:06 Go to next message
Bob Johnson
Messages: 1
Registered: July 2001
Junior Member
Why not just

select distinct f1,f2
from t1

or is this too easy?

Report message to a moderator

Re: Duplicate values only once [message #375118 is a reply to message #375054] Fri, 27 July 2001 10:36 Go to previous message
Siddharth Bahri
Messages: 18
Registered: March 2001
Junior Member
Hi bob,

I can't use this query

select distinct f1,f2
from t1

because the combination of fields f1 and f2 is distinct for all values in the database, f1 being the primary key.

This query will return all the rows in the table. while i wanted rows with distinct f2 values.

Don't bother now.

Thanks anyway.
Siddharth

Report message to a moderator

Previous Topic: Re: connect string
Next Topic: How can i make a parametarize filename in spool?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Jul 05 11:04:54 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.