Bug #2425 feat. requ. GROUP BY-Function FIRST
Submitted: 16 Jan 2004 6:40 Modified: 4 Oct 2005 17:22
Reporter: Robert Hawke Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server Severity:S4 (Feature request)
Version:4.0.17 OS:Linux (Linux)
Assigned to: 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