Re: simple max function?
From: Dieter Bender (dieter.bender_at_t-online.de)
Date: 06/19/04
- Next message: Roedy Green: "Documentation"
- Previous message: Glenn Robinson: "Re: Can't seem to UPDATE dBase table"
- In reply to: Raquel: "Re: simple max function?"
- Next in thread: Lee Fesperman: "Re: simple max function?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Date: Sat, 19 Jun 2004 11:11:16 +0200
Raquel wrote:
> Guess I am not understanding your question well...though it might be
> vendor dependent, I am not sure which vendor would NOT provide MAX
> functionality on non-columns. I work on DB2 and the syntax for MAX is:
>
> MAX(expression)
>
> where expression might be a column-name or a 'constant'. I checked
> MAX(2,3,4) here on DB2 and sure enough, it returned 4.
in my opinion thats no contradiction to sql standard. (2, 3, 4) is treated
as a table with one column.
Dieter Bender
>
> Regards,
> Raquel.
- Next message: Roedy Green: "Documentation"
- Previous message: Glenn Robinson: "Re: Can't seem to UPDATE dBase table"
- In reply to: Raquel: "Re: simple max function?"
- Next in thread: Lee Fesperman: "Re: simple max function?"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
