here's the table structure
CREATE TABLE GemGame (
ID int(11) NOT NULL auto_increment,
Score int(11) NOT NULL default '0',
LEVEL int(11) NOT NULL default '0',
username varchar(100) NOT NULL default '',
logged_time bigint(30) NOT NULL default '0',
PRIMARY KEY (ID)
) TYPE=MyISAM;
i just need a query that would show the highest 5 scores from each level
i think there's a way to do it.. but i couldn't figure it out. any help is appreciated. thanks!