Re: Need help on sqlplus script

Exactly two C's?

select student
from student_table
group by student
[Quoted] having count(grade) = 2;

Anything more complicated, please give table structure and structure of the output you wish from the query.

Hth,
Radu
[Quoted] "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:07:20 CEST