row limits

[fidel]

Hi pals

SELECT JID, JState, JClass, JClass2, JTitle, JState
FROM JPosts
WHERE `JobClass` ='Designers'
ORDER BY JTitle, JState

With this giving many results per state:

a) how can the results be limited to 2 rows per JState?

b) how to limit to 2 of the same JClass2 per JState (where JState still has 2 row maximum also)

notes:
JTitle is a job title
JClass2 is a 2nd type class, here it could be 'Floor_Designers'

Thanks -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[almond]

Fidel

a) which two?
b) which JClass2?

couldn't give answer on that. -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --