Unique rows 1

[newfriends1981]

Hello all,

please conside the following table "photo"

id employee_id photo_name
---------------------------------------
1 2 abc.jpg
2 2 xyz.jpg
3 5 acd.jpg
4 2 sis.jpg
5 3 sfs.jpg
6 5 iii.jpg
7 2 ier.jpg
---------------------------------------

now what I want is this table should select all the fields with unique employee_id (i.e. query should select total 3 rows with employee id 2,3,5) and everythime the query should select different picture(which can be done using random() )

Can anyone help me with this problem?

Thank you,

newfriends1981

 

[feherke]

Hi

[b]select[/b]
employee_id,(
  [b]select[/b]
  photo_name
  [b]from[/b] photo
  [b]where[/b] p.employee_id=employee_id
  [b]order by[/b] random()
  [b]limit[/b] 1
) [b]as[/b] photo_name
[b]from[/b] photo p
[b]group by[/b] employee_id

Feherke.

http://rootshell.be/~feherke/