SELECTING with multiple WHERE conditions on same column from sqlserver : I want to pic values from same column using and clause query is something like this.

select * from degree_detail_result where course_id=1 and course_id=2 and course_id=3 

tell me the solution of above query.