Re: Select the most recent date

From: Steve Kass (skass_at_drew.edu)
Date: 04/26/04 

Date: Mon, 26 Apr 2004 02:27:34 -0400

SELECT TOP 1 WITH TIES <column list> ... ?

SK

Aaron Bertrand [MVP] wrote:

>SELECT TOP 1 <column list> FROM table
> ORDER BY <date column name> DESC
>
>(Also, get ready for Celko to pounce for calling them records, not rows, and
>fields, not columns.)
>
>
>

Relevant Pages

  • Re: Select the most recent date
    ... >> (Also, get ready for Celko to pounce for calling them records, not ... constraints, Declarative Referential Integrity, datatypes, etc. in your ...
    (microsoft.public.sqlserver.programming)
  • Re: Need KB823291 Hotfix - how to get it without risking huge $$$$?
    ... state you are calling about a hotfix. ... >>Jupiter Jones [MVP] ...
    (microsoft.public.windowsxp.perform_maintain)
  • Re: Im not happy.
    ... of us are in it to give back to the community. ... Where did you get the idea for that I am interested in an MVP? ... Are we talking about Usenet groups or MVP program? ... Calling an illegal alien an "undocumented worker" is like calling a ...
    (microsoft.public.windowsxp.general)
  • Re: Assigning apartment to a COM component
    ... Microsoft MVP, MCSD ... > at the same time is calling C and is blocked and starts a modal loop. ... > what I did to workaround the problem. ... >> MVP VC FAQ: http://www.mvps.org/vcfaq ...
    (microsoft.public.win32.programmer.ole)
  • Re: oem vs retail full version
    ... Jupiter Jones [MVP] wrote: ... > name calling. ... > If he truly felt he could defend his point of view, ... > Instead he has to stoop to personal attacks in the misguided belief ...
    (microsoft.public.windowsxp.general)