Unique rows 1

newfriends1981 · Mar 2, 2007

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 · Mar 3, 2007

Hi

Code:

[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/

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Unique rows 1

newfriends1981

Programmer

feherke

Programmer

Similar threads

Part and Inventory Search

Sponsor