Sql Max Search
Join the DZone community and get the full member experience.Join For Free
Question: I'm trying to retrieve some info from an Oracle database. I've got a table named Scoring with two fields - Name and Score. What I want to get is the highest score from the table and the name of the player.
SELECT Name, Score FROM Scoring WHERE Score = (select Max(Score) from Scoring);