PostgreSQL selecting rows from table with specified condition

Question

I am using PostgreSQL database. I have a table course(id, c_name) and want to retrieve ids having enrolled to more than one courses

`I am trying following query but it doesn't return any record.

SELECT id FROM sub where c_name = 'comp' and c_name = 'maths'

Any help in this regard?

This is SQL 101 stuff. You really need to start with something like postgresql.org/docs/current/static/tutorial.html — Craig Ringer
– Craig Ringer, Commented Sep 3, 2013 at 7:00

Owen · Accepted Answer · 2013-09-03 06:59:00Z

1

select id, count(distinct c_name) 
from course 
group by id 
having count(distinct c_name) > 1

answered Sep 3, 2013 at 6:59

Owen

1,73611 silver badges15 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Thanks Owen. I have tried it and worked perfectly as i want. It was very useful for me.