Path: csiph.com!newsfeed.hal-mli.net!feeder3.hal-mli.net!newsfeed.hal-mli.net!feeder1.hal-mli.net!npeer01.iad.highwinds-media.com!news.highwinds-media.com!feed-me.highwinds-media.com!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail From: bradbury9 Newsgroups: comp.databases.ms-sqlserver Subject: Re: Database query -- how to? Date: Thu, 12 Apr 2012 04:10:36 -0700 (PDT) Organization: http://groups.google.com Lines: 37 Message-ID: <26142844.921.1334229036077.JavaMail.geo-discussion-forums@ynkf14> References: <67dc35a7-ea2e-4eb1-8bd4-7c7218c1e8e2@2g2000yqp.googlegroups.com> <33102916.190.1334222912192.JavaMail.geo-discussion-forums@vbbbg2> <14349368.675.1334223516823.JavaMail.geo-discussion-forums@yneo2> NNTP-Posting-Host: 195.57.19.36 Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable X-Trace: posting.google.com 1334229895 16484 127.0.0.1 (12 Apr 2012 11:24:55 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: Thu, 12 Apr 2012 11:24:55 +0000 (UTC) In-Reply-To: <14349368.675.1334223516823.JavaMail.geo-discussion-forums@yneo2> Complaints-To: groups-abuse@google.com Injection-Info: glegroupsg2000goo.googlegroups.com; posting-host=195.57.19.36; posting-account=jIl9nQoAAAA9P37IIqQq64yAx-2NQYiu User-Agent: G2/1.0 X-Received-Bytes: 2322 Xref: csiph.com comp.databases.ms-sqlserver:975 El jueves, 12 de abril de 2012 11:38:36 UTC+2, Gerd Brix escribi=F3: > Am Donnerstag, 12. April 2012 11:28:32 UTC+2 schrieb bradbury9: > > El jueves, 12 de abril de 2012 10:02:09 UTC+2, Gerd Brix escribi=F3: > [...] > > > There's a SQL Server Express with the following table: > > >=20 > > > ID TIME > > > ---------------- > > > 1 8:00 > > > 1 7:45 > > > 2 6:00 > > > 3 5:00 > > > 2 7:59 > > >=20 > > > What I need to find out is the last time entered for all given IDs. > > > That means: > > > ID TIME > > > ---------------- > > > 1 8:00 > > > 2 7:59 > > > 3 5:00 > > >=20 > > > Can someone please help me with this? > > >=20 > [...]=20 > > In case the column TIME is DateTime type: > > Select max(TIME) from TableName > >=20 > [...] >=20 > Not really :-( This only delivers the latest entry. What I need is the l= atest entry for each ID. The example result shows this: 3 rows instead of o= nly 1. >=20 > -gerd select [id], max(time) as latestTime from tableName group by [id]