Re: Need help on sqlplus script

Sorry:
having count(grade) = 2
and grade = 'C';

"Radu Lascae" <r.nospam.lascae_at_wanadoo.nl> wrote in message news:ILFz7.211$%Z5.400_at_pollux.casema.net...
> Exactly two C's?
>
> select student
> from student_table
> group by student
> having count(grade) = 2;
>
> Anything more complicated, please give table structure and structure of
the
> output you wish from the query.
>
> Hth,
> Radu
> "Katrina James" <jkatrina88_at_hotmail.com> wrote in message
> news:5f750bef333643e2ea2fbc89d82cf1f5.34531_at_mygate.mailgate.org...
> > Hi,
> >
> > I am writing a sqlplus script to list those student with grades 'A',
'B',
> and
> > only 2 'C'. I know how to write it will A, B, & C but the problem is
with
> > those student who has grade with 'C' it can only be two 'C'.
> >
> > If anyone know I can approach this, please let me know. I will
appriciate
> it
> > very much
> >
> > Kathrina.
> >
> >
> > --
> > Posted from [168.20.194.122]
> > via Mailgate.ORG Server - http://www.Mailgate.ORG
>
>
Received on Thu Oct 18 2001 - 21:09:06 CEST