Pages

Showing posts with label SQL In clause. Show all posts
Showing posts with label SQL In clause. Show all posts

Thursday, 13 March 2014

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)