Saturday 14 September 2013

SQL IN

IN:- it is used to provide multiple values in "where" clause.
so we select multiple rows by providing the specific value.
table on which we perform operation.
                                                                 
Ex:-after in operator we pass the multiple value in the parenthesis
in this example we pass 2 value.so it return id 2 and 3.



Ex:-here we select entire data from the table based on value we pass after "in" clause



No comments :

Post a Comment