The tables of a database are frequently listed by developers and DBAs. There are various methods for seeing the tables depending on whether you want
Category: RDBMS
ISNULL in MySQL and SQL Server
ISNULL function behaves differently in MySQL and Microsoft SQL Server. In MySQL, ISNULL tests whether the given expression is NULL. It returns 1 if the
Compare Strings in MySQL
In SQL, a built-in function is a programming object that takes zero or more inputs and returns a value. A feature that is built into
FIND_IN_SET function in MySQL
If a string is found in a string list with N substrings, the “Find in set” function returns a value in the “1 to N”
DATEDIFF_BIG Function in SQL Server
This function returns the number of times the specified date part boundaries were crossed between the supplied dates (as a signed big integer value). The
SQL Assignment-2
This is a simple test or assignment to see how comfortable someone is using SQL at the beginner to advanced level. Exercises of this nature
Big Data & SQL 