If I\'m looking to find the highest GPA in a relationaldatabase schema, how woul

Question

If I'm looking to find the highest GPA in a relationaldatabase schema, how would I write that out in a SQLstatement? student sid number Name:varchar2 Gpa.number course   cid:varchar2 Department:varchar2 enroll    sid:number Cid:varchar2 Grade:varchar2 Would I write as such: Select sid, name, Gpa From    Student Where :n, Gpa > 3.0 ; If I'm looking to find the highest GPA in a relationaldatabase schema, how would I write that out in a SQLstatement? student sid number Name:varchar2 Gpa.number course   cid:varchar2 Department:varchar2 enroll    sid:number Cid:varchar2 Grade:varchar2 Would I write as such: Select sid, name, Gpa From    Student Where :n, Gpa > 3.0 ;

Explanation / Answer

You could do this multiple ways. I would use the max() function This I believe is the simplest query: SELECT MAX(Gpa) FROM student You could also write it as: SELECT Gpa FROM student WHERE Gpa = 4.0 Those queries will only return the Gpa. If you want the students idand name, include it in the select clause like this: SELECT Gpa, sid, Name FROM student WHERE Gpa = 4.0 Hope this helps. Let me know if you need more help writingqueries.

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.