data load from table

[#1]

Hi all,

I have attached a csv file.

where i need to load the data from the attached table.

For example:

column 1 : User_id

column 2: In the attached table i have user_id = 13 where i need the count of user_id = 13 where test_type = FinalTest.

column 3: count of user_id = 13 where is_correct_ans = 1;

column 4: count of user_id = 13 where is_correct_ans = 0;

table must look like below,

user_id	count_user_id	count_correct	count_incorrect
13	10	8	2
25	10	10	0
18	0	0	0

This thing i need during load time.

Thanks,

Pramod

[#2]

will u please explain about ordering. i am still stuck with that issue.