postgresql selecting rows from table with specified condition
I am using postgresql database. i have a table course(id, c_name) ,i want
to retrieve ids having enrolled to more than one courses
i am trying with following query but it doesn't give any record
SELECT id FROM sub where c_name = 'comp' and c_name = 'maths'
any one having answer please tell me thanks
No comments:
Post a Comment