sql distinct query

Description:

     Following query select all distinct program codes where agreemnt number is 101.
Distinct select unique value.

SQL Query:

select distinct programme_code from AMSAgreement_transaction_master
where agreement_no=101