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

Database query -- how to?

From	Gerd Brix <gbrix@gmx.de>
Newsgroups	comp.databases.ms-sqlserver
Subject	Database query -- how to?
Date	2012-04-12 01:02 -0700
Organization	http://groups.google.com
Message-ID	<67dc35a7-ea2e-4eb1-8bd4-7c7218c1e8e2@2g2000yqp.googlegroups.com> (permalink)

Show all headers | View raw

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

Back to comp.databases.ms-sqlserver | Previous | Next — 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