how to control the line displayed when using group
Posted: Thu Jun 08, 2006 5:21 am
ill make a basic form of the query im doing to make it easier for readers
query
select * from job group by company order by RAND() limit 10
the problem is the query shows only one entry under each company,
for example company ABC have two job record only one of those job are always showing.
is there a way i can control this so that the other jobs from the same company can be displayed at random?
query
select * from job group by company order by RAND() limit 10
the problem is the query shows only one entry under each company,
for example company ABC have two job record only one of those job are always showing.
is there a way i can control this so that the other jobs from the same company can be displayed at random?