Hey guys, I'm hoping to get some help with this: create table uses(userid integer, typeid integer); insert into uses values(1, 1); insert into uses values(1, 1); insert into uses values(2, 1); insert into uses values(2, 2);
now i'm trying to build a select that gives the result: userid | percent 1 1.0 2 0.5 Where percent is the percent of typeids for that userid where typeid=1. I've been trying to do this unsuccessfully for a couple days, so any help would be greatly appreciated. -- Cory Nelson http://www.int64.org
