How to get First or any one record from each group.

[JOHN9]

Hi Team,

I have a requirement like I wants to fetch single student from each class and each section. Please find the below sample data.

STUDENT_NAME	CLASS	SECTION
Xavier	X	A
Mark	X	A
Tomy	X	B
Tony	X	B
johan	XII	B
Antony	XII	A
George	XII	A
Philips	XII	A
john	XII	B
David	XII	C
Maria	X	B
john	X	B
David	XII	C

From This student table I needs to fetch any single user from each class and section as per below output.

STUDENT_NAME	CLASS	SECTION
Xavier	X	A
Tomy	X	B
johan	XII	B
Antony	XII	A
David	XII	C

anyone have gone through this scenario can you please help.

Your help much appreciated.

also let me know if we can achieve this from front end also.

[anat]

load maxstring(STUDENT_NAME) resident table group by CLASS,SECTION;

[rwunderlich]

Or 

load FirstValue(STUDENT_NAME) resident table group by CLASS,SECTION;

-Rob