| Oracle guidance [message #7020] |
Thu, 15 May 2003 12:55  |
Nazma Bepat
Messages: 34
Registered: May 2003
|
Member |
|
|
I have to create a unique listing of all student id’s that have a numeric grade of 95. Include the student id and section id of these student’s grade in the output.
This is what I cam up with....
Select student_id, section_id
From grade
Where grade = 95
Can someone please help me out.
Thanks
Nazma
|
|
|
|
| Re: Oracle guidance [message #7021 is a reply to message #7020] |
Thu, 15 May 2003 13:11  |
Keith Simson
Messages: 3
Registered: May 2003
|
Junior Member |
|
|
I'm not sure what it is you're asking. Using
Select Distinct student_id, ...
(or)
...
Where grade = 95
group by student ID, section_id;
might do the trick.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
