Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
load maxstring(STUDENT_NAME) resident table group by CLASS,SECTION;
Or
load FirstValue(STUDENT_NAME) resident table group by CLASS,SECTION;
-Rob