× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  • Subject: Re: SQL Question
  • From: Rob Berendt <rob@xxxxxxxxx>
  • Date: Wed, 12 Jul 2000 12:00:09 -0500

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
+---

As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.