Re: View and Select

"Nikki" wrote...
> Hi ,
>
> Can someone help me with this Select statement and creating a VIEW. TIA!!!
>
>
> 1)display all entries in the stock table where the stock name starts with a
> C
>
> 2)create a view called manager_cash that contains the manager number and the
> total cash in portfolios managed by the manager.
>
(snip)

Hi Nikki,

homework to do ;-)? Just a few hints so you can figure it out: 1) Look at the keyword LIKE in your docs and use it in the where clause. 2) Have a look at the function SUM and the GROUP BY clause.

hth,
Guido Received on Mon Feb 03 2003 - 08:31:08 CET