Re: SQL Question

[Rob Berendt <rob@xxxxxxxxx>]

I am not sure what you are trying to solve by just the first line, but, will 
the UNIQUE keyword help?





bvstone@taylorcorp.com on 06/29/2000 04:38:46 PM
Please respond to MIDRANGE-L@midrange.com@Internet
To:     MIDRANGE-L@midrange.com@Internet
cc:      
Fax to: 
Subject:        SQL Question

Question on SQL...

I have an order detail file.  The unique key is invoice number, sequence
number.  I want to only select records that are the first sequence number
for each invoice.

I've been playing, but I can't figure it out.  Something like (not
syntatically correct)

select * from orddetpf where odcst = '36000' 
order by odinv 
but only select min(seqno) group by invoice

I'd like to do it with a single select (no subquery) if possible.  This is
because I have an option for a user to either view all detail lines, or only
the first one of each order.  I already have the SQL statment for the first,
and would like to just modify it (dynamic SQL) depending on which "mode" the
user chooses.

Thanks!

Brad
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---


+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---