Re: select top N entries from several groups

Would you like:

INSERT INTO finaltable SELECT gp, val FROM temp where gp = 'A' ORDER BY val
DESC LIMIT 2;

best regards
R.Hnat