Articles by Falguni Thakker
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 …
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 …
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 …
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 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 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 …
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 …
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 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 …
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 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 …
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.
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 …
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 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 …