problem in select query

[Cookies]

this should work fine:

select student_id from (
   select distinct student_id,
      count(*) over (partition by student_id) courses
   from my_table
   where course in ('java','c'))
where courses = 2;