Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: SQL command/I'm stuck
Ric wrote:
> I'm using SQL 8.0.
>
> I have translated the English sentence of "Get supplier numbers and
> status for suppliers in Paris" to the SQL command:
>
> select s#, status from supplier where upper(city) = 'PARIS';
>
> I don't know what to type for "Get color and city for "non Paris"
> parts with weight greater than 10 (hint: <> is the operator for not)"
>
> Any help would be appreciated.
A bit of help for those trying to help you is in order.
Daniel Morgan Received on Mon Jul 01 2002 - 10:44:17 CDT