Home -> Usenet -> comp.databases.oracle -> SQL question

SQL question

From: sirirut vanichayobon <svanicha_at_cs.ou.edu>
Date: Thu, 13 Aug 1998 15:47:44 -0500
Message-ID: <35D350F0.CBCF2DAC_at_cs.ou.edu> 





Hi,



   I would like to use SQL (I don't want to use PL/SQL) with one
'select' command to retrieve Name and the highest scoret in that name as
the following.



Table:


  Name     Score



  Bill          10
  Bill          60
  Bill          30
  Tom        40
  Tom        10





Result:


  Name   Score



  Bill        60
  Tom      40





   Any help would appreciate.



Thanks,


-sirirut-
Received on Thu Aug 13 1998 - 22:47:44 CEST












Original text of this message