Groups > comp.databases.ms-sqlserver > #972

Re: Database query -- how to?

Path	csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!news.glorb.com!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail
From	bradbury9 <ray.bradbury9@gmail.com>
Newsgroups	comp.databases.ms-sqlserver
Subject	Re: Database query -- how to?
Date	Thu, 12 Apr 2012 02:28:32 -0700 (PDT)
Organization	http://groups.google.com
Lines	35
Message-ID	<33102916.190.1334222912192.JavaMail.geo-discussion-forums@vbbbg2> (permalink)
References	<67dc35a7-ea2e-4eb1-8bd4-7c7218c1e8e2@2g2000yqp.googlegroups.com>
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 1334222912 8760 127.0.0.1 (12 Apr 2012 09:28:32 GMT)
X-Complaints-To	groups-abuse@google.com
NNTP-Posting-Date	Thu, 12 Apr 2012 09:28:32 +0000 (UTC)
In-Reply-To	<67dc35a7-ea2e-4eb1-8bd4-7c7218c1e8e2@2g2000yqp.googlegroups.com>
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
Xref	csiph.com comp.databases.ms-sqlserver:972

Show key headers only | View raw

El jueves, 12 de abril de 2012 10:02:09 UTC+2, Gerd Brix  escribió:
> Hi all,
> 
> I'm not too firm with writing SQL queries, thats why I'm asking here
> for help.
> There's a SQL Server Express with the following table:
> 
> ID     TIME
> ----------------
> 1       8:00
> 1       7:45
> 2       6:00
> 3       5:00
> 2       7:59
> 
> 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
> 
> Can someone please help me with this?
> 
> Thanks in advance!
> 
> -gerd

In case the column TIME is DateTime type:
Select max(TIME) from TableName

If i is not DateTime, you will have to convert the data, heres a link to the documentation on Convert function and data types http://msdn.microsoft.com/es-es/library/ms187928.aspx

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

Database query -- how to? Gerd Brix <gbrix@gmx.de> - 2012-04-12 01:02 -0700
  Re: Database query -- how to? bradbury9 <ray.bradbury9@gmail.com> - 2012-04-12 02:28 -0700
    Re: Database query -- how to? Gerd Brix <gbrix@gmx.de> - 2012-04-12 02:38 -0700
      Re: Database query -- how to? bradbury9 <ray.bradbury9@gmail.com> - 2012-04-12 04:10 -0700
  Re: Database query -- how to? Erland Sommarskog <esquel@sommarskog.se> - 2012-04-12 11:10 +0000
    Re: Database query -- how to? Gerd Brix <gbrix@gmx.de> - 2012-04-12 04:33 -0700

csiph-web