http://snippets.dzone.com/posts Thu, 28 Aug 2008 21:58:49 GMT DZone Snippets: max code http://snippets.dzone.com/posts/show/3174 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. <br /> <br /><code> <br /> SELECT Name, Score <br /> FROM Scoring <br /> WHERE Score = (select Max(Score) from Scoring); <br /></code> <br /><http://www.techonthenet.com/sql/max.php> Tue, 19 Dec 2006 18:34:42 GMT http://snippets.dzone.com/posts/show/3174 Mickael (Mickael)