Friday, 18 March 2011

Select/Delete Multiple Record Using IN Command

Select Query:
Select * from Employee_Mst Where Id IN (1,2,3)
Select * from Employee_Mst Where varEmpname IN ('Nirav','Ashish','Rahul')

Delete Query:
Delete from Employee_Mst Where Id IN (1,2,3)
Delete from Employee_Mst Where varEmpname IN ('Nirav','Ashish','Rahul')




1 comment:

  1. thank u , n ple add more examples that hepl us

    ReplyDelete