| Date: | Fri, 12 May 2000 15:39:59 -0400 |
|---|
| Reply-To: | Alex Lin <first@BELLATLANTIC.NET> |
|---|
| Sender: | "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU> |
|---|
| From: | Alex Lin <first@BELLATLANTIC.NET> |
|---|
| Organization: | NJ DOE |
|---|
| Subject: | Display only the last duplicate record |
|---|
| Content-type: | multipart/alternative;
|
|---|
Hi,
I have several duplicate records on the database with different sequence
numbers. Would like to display only the last one. How could I do that
in SQL query ?
Thanks
Alex
--------------------------------------------------------------------
5118 9999 998 12-MAY-00 N 1 F F F F F F 2 12-MAY-00 205.148.5.77
5119 9999 998 12-MAY-00 N 1 F F F F F F 2 12-MAY-00 205.148.5.77
5120 9999 998 12-MAY-00 N 1 F F F F F F 2 12-MAY-00 205.148.5.77
--------------------------------------------------------------------
[text/html]
| 
