I have 2 tables, student and qualifications as mentioned below. I have to find the details of all students based on the required fields and the order of the records should be based on his marks , age, highest qualification, lowest qualification and the percentage of his lowest qualifications.

I have tried different queries where i have included all the necessary fields. But suppose if a student has 3 qualifications, the records are multiplied that many number of times.
FOR Ex:

```
Sr.No  Student_ID Highest Qualification Marks
1      001         Grad     SSC        80 
2      001         Grad     HSC        60 
3      001         Grad     Grad       80 
4      002         HSC      SSC        60 
5      002         HSC      HSC        50 
6      003         SSC      SSC        40 

```

This is the query which i have tried

```
SELECT std.stud_id, std.dob, std.highest_qual, MIN(std.lowest_qual) , std.marks
FROM student std
LEFT JOIN qualifications qual ON std.stud_id = qual.stud_id 
Where std.fees_paid ='Y'
ORDER BY std.marks, std.dob, std.highest_qual

```

Expected result:

```
001 23-04-1991 Grad SSC 80
002 20-09-1992 HSC  SSC 60
003 13-05-1992 SSC  SSC 40

```

Result from query: the query returns all the records instead of a single records for each student

```
001 23-04-1991 Grad SSC 80
001 23-04-1991 Grad HSC 60
001 23-04-1991 Grad GRAD 80
002 20-09-1992 HSC  SSC 60
002 20-09-1992 HSC  HSC 60
003 13-05-1992 SSC  SSC 40

```