emiliano Posted February 11, 2003 Share Posted February 11, 2003 hi everyone.. i have a problem with a sql query.. after searching and trying to understand what the manual says i'm trying to solve this problem with your help! i couldn't found in the sql manual (my english is pretty limited) a way to select "x" rows but i need that every record had a diferent category from each other... my table is something like this ID | TITLE | CATEGORY 1 Fly again 1 2 Shut up 2 3 Bye 3 4 Hello! 4 5 Mama mo 3 6 Payaso 2 I need to let say show 4 records.. the lastest one of each category.. but in only one result page.. i can't figure out how to do this with only one query, it'd be easy doing 4 queries, but i like challenges.. (althoug i'm losing this one at the moment).. thanks in advance emiliano patagonia, argentina Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.