Building a select distinct on mysql ( zend_db)

I HAVE THE FOLLOWING TABLE, I WOULD LIKE TO GET to do a select distinct on the the column [code], i don't need to get the "A" three times.

[ ID ]   [ CODE ]     [ LIBELLE ]
1         A        LIBELLE1  
2         B        LIBELLE2
3         C        LIBELLE3
4         A        LIBELLE4  
5         A        LIBELLE5
6         D        LIBELLE6 

I want the result as following

[ ID ] [ CODE ] [ LIBELLE ]
1         A        LIBELLE1  
2         B        LIBELLE2
3         C        LIBELLE3
6         D        LIBELLE6 

Answers


Just add

group by code 
ORDER BY code ASC

at end of your sql query

example

select * from table
group by code 
ORDER BY code ASC

 SELECT Min(Id) Id, Code, MIN(Libelle) Libelle
 from table
 group by code

If you are looking for Zend_Db_Select usage, here it is

$db->select()->from('table', array(
    'Id' => new Zend_Db_Expr('Min(ID)'),
    'Code' => 'CODE',
    'Libelle' => new Zend_Db_Expr('Min(LIBELLE)')
))->group('CODE');

$db should be your Zend_Db_Adapter.


Need Your Help

Rails create your own password reset

ruby-on-rails

I'm trying to understand the mechanics of creating a password reset functionality for a rails application with users and was wondering if someone could walk me through the boiler plate logic that s...

Why does my JTable over take my other JComponent

java swing layout jcomponent panels

I've been trying to sort this out for a while now, I have checked the docs (if you notice the table code is from there), and I just can't quite figure it out. Am I using the wrong containers or do I