Max / Min with a column list
-----------------------------
Key: CORE-3434
URL: http://tracker.firebirdsql.org/browse/CORE-3434
Project: Firebird Core
Issue Type: New Feature
Environment: SQL language
Reporter: mauro russo
Dear,
I would like to have a sintactical SQL option in order
to write somehitng like
MAX( col1, col2, ..., colK ) [AS (n1, n2, ..., nK) ]
in order to obtain not the maximum of a column, but
a "combined maximum" -> the maximum of col1 and the corresponding values of
col2, ..., colK [that is the
values col2, ..., colK in th only one row having the maximum col1 value].
If more rows have the same maximum value of col1, the query should chose (among
those) the row with maximum col2 value.
Again, if more rows share the same maximum col2 also, the query should look for
col3 value, and so on, until colK. If more rows
share until colK values, then all these rows are equivalent and anyone of them
can be chosen, exactly like when
only one maximum column value is searched,
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
Xperia(TM) PLAY
It's a major breakthrough. An authentic gaming
smartphone on the nation's most reliable network.
And it wants your games.
http://p.sf.net/sfu/verizon-sfdev
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
