Re: SQL Delete question

[Alan Shore <AlanShore@xxxxxxxx>]

Jim - have a look at the following

http://www.systeminetwork.com/resources/artarchive/index.cfm?fuseaction=viewarticle&CO_ContentID=14895&channel=art&PageView=Search

http://www.systeminetwork.com/resources/artarchive/index.cfm?fuseaction=viewarticle&CO_ContentID=14940&channel=art&PageView=Search



Alan Shore

NBTY, Inc
(631) 244-2000 ext. 5019
AShore@xxxxxxxx

midrange-l-bounces@xxxxxxxxxxxx wrote on 12/06/2006 11:55:34 AM:

> Greetings!
>
> I have a file that, among other fields, has Account_Number, Date,
Sequence
> number.
>
> In the file there are multiple occurrences of those three fields.
Example
> Account_Number     Date    Sequence_number
>             1             20061206           01
>             1             20061206           01
>             1             20061206           01
>             1             20061206           02
>             1             20061206           02
>             1             20061206           02
>             1             20061206           03
>             1             20061206           03
>             1             20061206           03
>             1             20061206           04
>             1             20061206           04
>             1             20061206           04
>
> What I am looking for is a way to delete all but one occurrence of the
> repeated data to get a file that looks like;
>
> Account_Number     Date    Sequence_number
>             1             20061206           01
>             1             20061206           02
>             1             20061206           03
>             1             20061206           04
>
>
> Is this something I can do with SQL?  If so, what would the SQL statement
> look like?
>
>
> Jim
>
> --
> Jim Essinger
> Senior Programmer/Analyst
> SLFIMA
> PO Box 1000
> Fruitland, ID  83619
> 208-452-4058 x133
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.