Where Operator Usage : In my last post I was talking about Where clause and its operators.Now I am going to describe its usage with Where clauses. There are different types of usage operators with our requirement. I will give all the operators usage process with some example. It is used with SELECT,INSERT,UPDATE & DELETE statement. I am giving it serially. Equal (=) :This operator is used when we comparing any value or characters with our required field. Like : SELECT * FROM table name WHERE column name= value. Where clause with AND : It is used when we have multiple condition.Just like: SELECT column - names FROM table - name WHERE condition1 AND condition2 For Update : UPDATE table - name SET column - name = value WHERE condition1 AND condition2. Where clause with OR : It is used when any one value is acceptable, like: SELECT col...
