SQL In clause

Description:

            Here  AMSAgreement is the table and it select all the rows whose agreement_no column contains
agreemnet number 101,243 and 250.

SQL Query:

select  * from AMSAgreement
where agreement_no in (101,243,250)