Re: Forms 4.5 - Unique Records

From: Pete Kolton <peter.kolton_at_nspmbtinternet.com>
Date: Thu, 25 Nov 1999 12:41:54 -0000
Message-ID: <81jam9$eqe$1@supernews.com>

You can do this by putting something like this into the block where clause...

1=2
union
select distinct <column_list> from table_name

Are you sure you really want to do this though?

--

---

Pete Kolton
ORACLE Systems Consultant
All reasonable offers considered :-)

Pete_at_kolton.com
http://www.kolton.com

---

Sanford Ross wrote in message <943502404.354253_at_news2.bigplanet.com>...
>Can you use the DISTINCT keyword in the query?
>
>Hope I understood your question,
>S. Ross
>
>KRM <malleykr_at_my-deja.com> wrote in message
>news:81gor1$o0o$1_at_nnrp1.deja.com...
>> Hello.
>>
>> How would I set up my block so that it only pulls in unique rows of
>> data? For instance, in one case, there are 8 rows in the database
>> (which are all different from each other), but the fields that I am
>> pulling in are not unique, in fact, there are only 2 different sets of
>> data. How can I set up the block to disregard the duplicates?
>>
>> Thanks,
>> KRM
>>
>>
>>
>> Sent via Deja.com http://www.deja.com/
>> Before you buy.
>
>
Received on Thu Nov 25 1999 - 06:41:54 CST