FW: how to write this sql query

Yes, It is working. Thanks!

Guang

> -----Original Message-----

Guang,
  Add MAX(score) over() to your query and that should do it, so:

 select DISTINCT QUERYID,
 FIRST_VALUE(SUBJID) OVER (PARTITION BY QUERYID ORDER BY score DESC),  MAX(score) OVER()
from blastresults where QUERYID=62;

• ant

  ---

  Please see the official ORACLE-L FAQ: http://www.orafaq.com

  ---

  To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

  ---