using distinct and max together

Article View: bit.databases.mssql-l

Article #11

Back to bit.databases.mssql-l Previous Next

#11

From: Bernard Lechler
Date: Fri, 20 Feb 2004 22:19

18 lines
1354 bytes

Hi,

I have a table somewhat akin to:
-------------------------------------------
| recnum |  docurl  | lastupdated| author |
-------------------------------------------
| 1      | foo.htm  | 01/01/2004 | joe    |
| 2      | foo2.htm | 02/02/2004 | bob    |
| 3      | foo.htm  | 02/02/2004 | jane   |
-------------------------------------------

I have been to no avail trying to find a query that will return to me
the distinct docurls which were most recently updated with the
associated author.

Any help is appreciated.

Bernie

Technical Details

Message-ID: <96e43d2a.0402201419.7ee0e466@posting.google.com>

Path: arc1-ca.pugleaf.net!archiver1.google.com!postnews1.google.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: f6611,1abe136f6091fb93,start
X-Google-Attributes: gidf6611,public
X-Google-ArrivalTime: 2004-02-20 14:19:02 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!postnews1.google.com!not-for-mail
From: blechler2000@yahoo.com (Bernard Lechler)
Newsgroups: bit.databases.mssql-l
Subject: using distinct and max together
Date: 20 Feb 2004 14:19:01 -0800
Organization: http://groups.google.com
Lines: 18
Message-ID: <96e43d2a.0402201419.7ee0e466@posting.google.com>
NNTP-Posting-Host: 12.20.58.68
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1077315542 23051 127.0.0.1 (20 Feb 2004 22:19:02 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Fri, 20 Feb 2004 22:19:02 +0000 (UTC)