Re: How do I select distinct values when user executes query?

From: Josue Batista <jbatista_at_my-deja.com>
Date: Thu, 22 Jul 1999 02:58:57 GMT
Message-ID: <7n61dc$fli$1@nnrp1.deja.com>

To get all ship_no unique values try:

SELECT DISTINCT SHIP_NO
FROM your_table_name

Hope that helps.

Josue

In article <37960ec7.8217905_at_news.ikea.com>, me_at_me.com (John Smithy) wrote:
> Hi,
>
> I know this is probably dumb. I have a single table with all my data.
> One column is called ship_no. For each ship_no, there are many
> rows. So when a user queries on this, he/she will see many rows
> for each ship_no. I have this table divided into three blocks. The
> master block just has ship_no. The details are in the other blocks.
> The user will query on ship_no. I only want to display the unique
> value. Can someone help me out? I am a new Oracle Developer.
>
> Thanks,
> John
>

--
Josue_at_abcsolutions.org
ABC Tech Solutions
http://www.abcsolutions.org
[Java/Oracle/Linux] [C/S & Internet Database Apps]

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Wed Jul 21 1999 - 21:58:57 CDT