Database set operations

Database set operations Database set operations – As we have ᴖ, ᴗ, – operations in algebra, same we have Union, Intersect and except operations in SQL. Like Union, Intersection and set difference operation in relational-algebra, the tables participating in these operations must be compatible that is, that they must be of the same arity and …

SQL String operations

SQL String operations SQL String operations : SQL provides LIKE operator for performing pattern matching, this is one of the most important features of SQL, and very handy in retrieving data from the existing database. Instead of specifying the entire string, we can specify only some specific part of the match to be found. The following two special …