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

Home -> Community -> Usenet -> c.d.o.misc -> HELP new to sql min query

HELP new to sql min query

From: Chris <christian_at_fleming77.freeserve.co.uk>
Date: Mon, 22 Feb 1999 22:18:46 -0000
Message-ID: <7asl7q$7jt$1@news8.svr.pol.co.uk> 





I am trying to return the name value from one table where it equals a min
amout in another  code below but it always come back no rows selected can
anyone help  as i am new to sql



select cname from cust, rental


where cname in (select min(milesin - milesout) from rental;



Received on Mon Feb 22 1999 - 16:18:46 CST












Original text of this message













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