Description:
Here AMSAgreement is the table and it select all the rows whose agreement_no column containsagreemnet number 101,243 and 250.
SQL Query:
select * from AMSAgreement
where agreement_no in (101,243,250)
Showing posts with label In clause in SQl. Show all posts
Showing posts with label In clause in SQl. Show all posts
Thursday, 13 March 2014
SQL In clause
agreemnet number 101,243 and 250.
select * from AMSAgreement
where agreement_no in (101,243,250)
Subscribe to:
Posts (Atom)