Bug #2425 feat. requ. GROUP BY-Function FIRST

• Submitted: 16 Jan 2004 6:40
• Modified: 4 Oct 2005 17:22
• Reporter: Robert Hawke
• Status: Duplicate
• Category: MySQL Server
• Severity: S4 (Feature request)
• Version: 4.0.17
• OS: Linux (Linux)
• CPU Architecture: Any

[16 Jan 2004 6:40] Robert Hawke

Description:
I'm missing the First() Funktion that exists in Access or MSSQL

eg. to get a list of all Countries in your DB.

table:
username|country
------------------
robert  |austria
melanie |germany
bill    |austria
babs    |italy
hank    |germany  

SELECT First(Country) FROM users GROUP By Country.

output:

country
-------
austria
germany
italy

How to repeat:
feat. requ. 

Suggested fix:
feat. requ.

[4 Oct 2005 17:22] Hartmut Holzgraefe

duplicate of feature request in bug 2020