[thelist] SQL Max Query Distinct

[Chris W. Parker]

> -----Original Message-----
> From: Michael Barrett [mailto:mbarrett at triad.rr.com]
> Sent: Thursday, November 14, 2002 2:35 PM
> To: thelist at lists.evolt.org
> Subject: Re: [thelist] SQL Max Query Distinct
>
>
>
>
> > LOL I wasn't gonna say anything... ;)
> >
> >> select id, max([pleasetellmeyoudidn'tnameyourdatefield"Date"])
>
> Now, I'm a bit of a database n00b.
> Why wouldn't you name a column "date" if that's what's in it?

i think because it is most likely a reserved word and could/would
conflict with things. at least, that's what i ran in too. ;)

chris.