how to control the line displayed when using group

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
User avatar
x
Forum Newbie
Posts: 12
Joined: Wed Jun 08, 2005 11:31 pm

how to control the line displayed when using group

Post by x »

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?
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

lose the group by.
Post Reply