Using my below query how to use the where condition in my sql query

See more:

C#

My query as follows;

select  Distinct Faculty_Name = (select top 1 facname from faculty where facid = bfid), Rating = (case rate when '1' then 'Excellent' when '2' then 'Good' when '3' then 'Fair' when '4' then 'Poor' when '0' then 'Not Applicable' end)

from facfeedback

when i execute the above sql query output as follows;

Faculty_Name      Rating

  Ramesh           Excellent
  Ramesh           Good
  Suresh           Fair
  Suresh           Poor

but using my above query i want to see the particular Faculty_Name rating for that how can i write the query using where condition using above sql query.

suppose i want to see the particular Facutly_Name (Ramesh) for that how can i write the query.

please help me.

Regards,
Narasiman P.