Articles by Falguni Thakker
LEFT OUTER JOIN in SQL: Syntax, Examples, and NULL Handling
Learn how SQL LEFT OUTER JOIN works with clear examples, output, NULL handling, and common mistakes that cause unexpected results.
How to Delete Row in SQL Server [10 Practical Examples]
sql delete multiple rows, sql delete row if exists, sql delete all rows, sql delete duplicate rows, sql delete from select, sql delete row where column …
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 Temp Tables are a Blessing or Disastrous Curse?
Learn how to optimize your database queries and boost your SQL skills with our comprehensive guide on SQL Temp Tables. From basic syntax to advanced features, …
Getting started with SQL - Detailed Explanation
Getting started with SQL. Overview on relational database, What is SQL, Comparison between SQL and MySQL, Steps to install SQL on both Windows and Linux …
35+ SQL Functions Explained in Detail [Practical Examples]
Related Keywords: sql create function, sql functions example, sql function syntax, oracle sql functions, sql functions list pdf, function in sql server, sql …
Foreign Key in SQL Usage Explained [Practical Examples]
Foreign Key in SQL can be specified as the referential integrity in Relational Database management system, in technical term foreign key in SQL is a constraint …
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 …
Find and Delete Duplicate Rows in SQL [100% Working]
Learn how to find and delete duplicate rows in SQL or completely delete records in SQL including Joins using different methods. You can also automate the …
How to Query Data between two Dates in SQL? [SOLVED]
Querying data effectively is a fundamental skill when working with SQL databases. One common, yet crucial, aspect of this is understanding how to query data
How the Hell I use SQL IF Statement in SELECT [5 Methods]
Dive deep and tame the powerful beast of sql if statement in select, mastering the art of dynamic and conditional SQL queries with ease and precision.
5 Functions to Efficiently Roundup in SQL? [100% Working]
Explore the dynamic capabilities of ROUNDUP in SQL to enhance numeric data precision and optimize query performance. Elevate your database operations with the …
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.
Learn to use SQL ORDER BY like a PRO with Our Guide
Enhance your SQL queries with advanced SQL ORDER BY techniques. Elevate the efficiency and functionality of your database interactions.
Use SQL Ranking Functions Like a PRO: Don't be a Rookie
Explore the transformative potential of SQL Ranking Functions to revolutionize your database queries and analytics. Dive deep into robust strategies, avoid …
SQL TRUNCATE Table : Potent but Risky Command
Unlock the powerful capabilities of SQL Truncate Table to optimize database performance. Discover essential insights, best practices, and crucial considerations …
How to Precisely Get Date from DateTime SQL? [7 Methods]
Discover powerful and efficient methods to get date from DateTime SQL with our insightful guide. Explore expert techniques to enhance your SQL queries, ensuring …
SOLVED: SQL ambiguous column name [5 Possible Causes]
ambiguous column name join, sql ambiguous column name, ambiguous column name, ambiguous column name sql, column reference is ambiguous, ms sql ambiguous column …
SQL CONTAINS Explained [Practical examples]
we have covered the SQL Contains which is used to do the searching operation for a word or phrase or nearby word on a full-text index, we have started with an …
Using SQL GROUP BY with Multiple Columns [SOLVED]
Learn to use SQL GROUP BY Multiple Columns (Two, Three or More) using different methods such as using with HAVING BY, ORDER BY, Joins, ROLLUP and CUBE.
Using SQL UPDATE from SELECT statement [7 Methods]
There are 3 different methods to use SQL UPDATE from Select. Using INNER Join, Using Merge statement and using sub query statement.
SQL String Concatenation [5 Methods]
In this comprehensive article, we will delve into the world of SQL string concatenation, exploring its fundamentals, various techniques, and best practices to
SQL Remove Characters from String with Examples [SOLVED]
SQL remove characters from string from left side, right side. Remove first character, remove last character, remove last n characters, remove specific …
How to PROPERLY insert multiple rows in SQL? [SOLVED]
Learn how to insert multiple rows in SQL with ease. Discover batch inserts and the power of INSERT INTO statements with UNION ALL. Streamline your data …
How to select row with max value in SQL? [SOLVED]
There are two ways to find and select rows with maximum value in a column. 1. Sub query with Max() Function 2. Left Outer join
SQL IN Operator Explained [10 Practical Examples]
SQL IN with Numeric list of values, with String list of values, with Date list of values, with Subquery, with columns, Multiple SQL IN in a single query, with …
How to UPDATE statement with JOIN in SQL? [SOLVED]
A SQL update with join is a query used to update the data in a table based on data in another related table. The join is used to associate records in one
How to connect Free SQL database to VS Code? [SOLVED]
Connecting a free SQL database to VS Code can be a great way to enhance your development workflow and streamline your data management processes. By using a
How to send email at specific time interval in SSRS? [SOLVED]
SQL Server Reporting Services (SSRS) is a powerful reporting tool that allows users to create, manage, and deliver a wide range of reports. One common
Boost Your Search Game with MySQL Related Tags!
When it comes to organizing large amounts of data on a website, tags can be an incredibly helpful tool. By assigning specific keywords or phrases to different
How to search SQL for column name? [SOLVED]
A database in SQL has multiple tables and each table has contain multiple columns. In SQL, We can search for a specific column name in a table by using the
How to use SQL delete with JOIN? [SOLVED]
SQL delete where join is the combination of SQL JOIN and SQL delete statement. SQL delete statement is used to delete records from a table where as SQL JOIN
SQL select first row in GROUP [SOLVED]
In this tutorial we will cover different methods and examples to select first row in GROUP BY clause group in SQL. But before that let us create a sample
Insert results of stored procedure into temp table [SOLVED]
In this article of Insert into temp table stored procedure, We have covered overview of SQL stored procedure, how to create stored procedure in SQL, syntax of …
How to combine rows into one string in SQL [SOLVED]
We have covered an overview of combine string rows, list out all three methods of combining rows into one string which are using COALESCE, USING XML PATH, and …
Select duplicate records in SQL table [SOLVED]
In this article of select duplicate records in SQL, we have covered an overview of SQL duplicate records, steps to select duplicate records in SQL , why to
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
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 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 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 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 COUNT, AVG, SUM Functions | Aggregate Functions in SQL
SQL COUNT, AVERAGE and SUM are most commonly used aggregate functions of SQL.
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 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 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 …
Concat SQL Function Explained [Practical Examples]
Concat SQL function is used to concatenate strings. difference between SQL concat and SQL concat_ws.
SQL WITH Clause Explained [Practical Examples]
The SQL WITH clause allows you to give the name to the output of referenced in subsequent queries, this process is interchangeably called as common table …
SQL DISTINCT Explained [Practical Examples]
SQL Distinct with SQL select statement, on one column and on multiple columns, difference between SQL Distinct and Group By clause and SQL Distinct with SQL …
SQL BETWEEN Explained with Practical Examples
SQL between syntax and examples. Using with update and delete statement. SQL NOT between examples and syntax, SQL Between Range with Numeric values
SQL Replace Function Explained [Practical Examples]
SQL REPLACE performs comparisons based on the collation of the input. To perform a comparison in a specified collation, you can use COLLATE to apply an explicit …
SQL RANK Function Explained [Practical Examples]
Practical examples of SQL RANK function with a single table, multiple tables, with partition argument and ORDER BY ASC and DESC, also mention an example of SQL …
SQL If Statement Tutorial [Practical Examples]
practical examples to use sql if statement explained. Use multiple if conditions, sql if else condition, sql nested if else condition with examples
SQL Not Equal Tutorial [Practical Examples]
SQL Not Equal is a comparison operator used to compare two not null operand values or an expression, if the left operand value is not equal to the right operand …
DATEADD SQL Function Tutorial [Practical Examples]
DATEADD SQL date function that is used for manipulating DateTime datatype values, DATEADD function is used to add or subtract the specific numerical value to a …
How to PROPERLY add comments in SQL [Multiple Ways]
We will cover different practical examples to explain how to add SQL comments for Single line comments, Multi-line comments, Inline comments
SQL Data Types Explained [Practical Examples]
an overview of SQL data types, also define a list of SQL data types, we have explained each category of data types and described each category data type with …
How to alter table and add column SQL [Practical Examples]
In SQL, to add column(s) to the existing table SQL ALTER TABLE ADD statement is used, there is no statement like SQL ADD COLUMN to add the column or to modify …
Delete table in SQL / DROP TABLE in SQL [Practical Examples]
In this article of delete table in SQL, we have covered the delete table command DROP TABLE used to delete a table in SQL with syntax and explanation of each …
SQL INSERT INTO SELECT with Practical Examples
This article of SQL INSERT INTO SELECT, the article begins with the overview of SQL INSERT INTO SELECT with syntax, use of each syntax argument and clause, the …
SQL OUTER JOIN Explained [Practical examples]
SQL OUTER JOIN is used to preserve all of the records that have values in either the left or right table, In the SQL OUTER JOIN all the content of both tables …
SQL LIMIT Usage Explained [Practical Examples]
We have covered practical examples of SQL LIMIT starts with simple example LIMIT with number of rows , order by clause, left outer join , where clause
SQL Exists Explained in Detail [Practical Examples]
We have covered the overview of the SQL Exists operator, define the use of SQL Exists, Syntax of how to use SQL Exist with an explanation of each syntax …
SQL FULL OUTER JOIN Explained [Practical Examples]
Examples to use SQL Full Outer Join with two tables, three tables, multiple tables with Where Clause, multiple tables with Group by Clause, Using Union Clause, …
SQL TOP Explained [Practical Examples]
SQL TOP clause is used to limit the records returned as the result set of SQL select query by specified number of rows or percentage of rows in SQL Server.
SQL Domain Constraints (NOT NULL, Check, UNIQUE)
Domain constraint is used to restrict the values to be inserted in the column or relation, domain constraint defines a valid set of values for a table
SQL Transactions Explained [Practical Examples]
SQL Transactions consists of a sequence of SQL statements and/or queries, the SQL standard specifies that a transaction begins implicitly when an SQL
SQL Stored Procedure Explained [Practical Examples]
SQL stored procedures are generally precompiled group of an ordered series of Transact-SQL statements stored into a single logical unit which allow for
SQL Mapping Carnality Explained with Examples
SQL mapping cardinalities define the relationship between the entities or tables of one relationship set with the entities or tables of another relationship
SQL Floor() function Explained [Practical Examples]
sql floor, floor sql, floor function in sql, floor in sql, floor sql server, sql floor function, sql server floor
SQL Drop Constraint Explained [Practical Examples]
drop constraint, drop constraint sql server, sql drop constraint, drop sql constraint, sql server drop constraint, drop foreign key sql server, alter table drop …
SQL add column with default value to an existing table [SOLVED]
SQL ALTER TABLE statement is used to make changes in the existing SQL table and can be used to add column with default values
How to import SQL file using CLI in MySQL?
We are covered overview of .sql file , steps to import .sql file , how to open MySQL command line , how to change current database using USE command , and also …
SQL NOT IN Operator Explained [8 Practical Examples]
Examples of SQL NOT IN with Numeric list of values, String list of values, Date list of values, Subquery, columns, Update statement, Delete statement, HAVING …
SQL RIGHT OUTER JOIN Explained [Practical Examples]
SQL RIGHT OUTER JOIN is one type of SQL OUTER JOIN used to retrieve all records from the right table of the join and match records from the left table side of …