Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.oracle -> Re: SQL Problem

Re: SQL Problem

From: AK <ak_tiredofspam_at_yahoo.com>
Date: 16 Jul 2004 11:30:45 -0700
Message-ID: <46e627da.0407161030.42e5e818@posting.google.com>


CASE WHEN ROW_NUMBER() OVER(PARTITION BY NAME ORDER BY SCORE) = 1 THEN NAME ELSE NULL END Received on Fri Jul 16 2004 - 13:30:45 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US