Never been to DZone Snippets before?

Snippets is a public source code repository. Easily build up your personal collection of code snippets, categorize them with tags / keywords, and share them with the world

Sql max search (See related posts)

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);

<http://www.techonthenet.com/sql/max.php>
to sql max by Mickael on Tue Dec 19 13:34:42 -0500 2006

You need to create an account or log in to post comments to this site.


Click here to browse all 4860 code snippets

Related Posts