Articles by Falguni Thakker
Concat SQL Function Explained [Practical Examples]
Concat SQL function is used to concatenate strings. difference between SQL concat and SQL concat_ws.
SQL NOT NULL Constraint Explained [Easy Examples]
The SQL NOT NULL constraint on an attribute or column specifies that the NULL value is not allowed for that attribute, in other word, the constraint in SQL …
SQL ISNULL Function Explained [Easy Examples]
SQL ISNULL is Advanced SQL function which takes two parameters first one is expression or column name and second is value which is return if expression or …
SQL Left Join Multiple Tables [Easy Examples]
Examples to use SQL LEFT JOIN Multiple tables. In SQL Left join, if a specific row is present in the left table but not in the right, the result will include …
SQL Union Operator Explained [Easy Examples]
SQL Union Operator or clause is a one of the SQL Set operators which is used to merge or combine two or more SQL Select Query results into single result set.
SQL COUNT, AVG, SUM Functions | Aggregate Functions in SQL
SQL COUNT, AVERAGE and SUM are most commonly used aggregate functions of SQL.
SQL Server COALESCE Function with Practical Examples
The SQL Server Coalesce() function is a basic SQL function which is used to evaluate the list of values and return the first occurrence of non-NULL value. The …
SQL SUBSTRING Function Explained [Beginners]
SQL mainly provides three truncate functions which are working with string. SQL Substring Function, SQL Left Function, SQL Right Function
SQL LIKE | SQL NOT LIKE | SQL LIKE WILDCARD Examples
SQL like comparison operator is used to compare or to manipulate text with regular expression. There is a condition where we need to fetch records which do not …
SQL GROUP BY Statement Explained with Practical Examples
The GROUP BY clause is part of SQL SELECT statement. Optionally it is used in conjunction with aggregate functions to produce resulting group of rows from the …
SQL CREATE TABLE Statement with Practical Examples
Data stored in the database is logically stored in data tables, using SQL Create Table statement we can create data tables in the database management system
Master SQL CASE Statement: Don't Just Be a Beginner
Unlock the full potential of your database with our expert guide on SQL Case. Learn potent strategies to navigate data complexities and revolutionize your …
Unlock the Power of SQL UPDATE with Advanced Techniques
Learn to turbocharge your databases with optimization techniques and best practices that will make your SQL UPDATE statements more powerful and efficient.
SQL RIGHT JOIN Explained with Syntax, Scenarios & Practical Examples
Learn SQL RIGHT JOIN with syntax, visual explanation, and practical scenarios. Understand how RIGHT JOIN works, how it differs from LEFT JOIN, how NULL values …
SQL LEFT OUTER JOIN Explained with Examples (LEFT JOIN vs INNER JOIN vs RIGHT JOIN)
Learn SQL LEFT OUTER JOIN with clear examples and diagrams. Understand LEFT JOIN vs INNER JOIN, LEFT JOIN vs RIGHT JOIN, syntax, NULL handling, and practical …