Skip to content

Tag Archives: DBMS-SQL

Overview :Structured Query Language or SQL is a standard Database language that is used to create, maintain and retrieve the data from relational databases like… Read More
Fuzzy Search :A technique of finding the strings that match a pattern approximately (rather than exactly). Users / Reviewers often capture names inaccurately. Typing mistake… Read More
Here we are going to see how we can compare the columns of two different tables in SQL. We will be taking a few examples… Read More
The purpose of this article is to make a simple program to Join two tables using Join and Where clause in SQL. Below is the… Read More
Here we will see how to add unique key constraint to a column(s) of a MS SQL Server’s database with the help of a SQL… Read More
The aim of this article is to make a simple program to Join two tables using Join and Where clause using MySQL. Below is the… Read More
Structured Query Language or SQL is a standard Database language that is used to create, maintain and retrieve the data from relational databases like MySQL,… Read More
Introduction :   One of the pre-needful of Database Performance Health Check is to have access to the database which we’re going to tune. As… Read More
The T-SQL function OUTPUT, which was introduced in 2005, can be used to insert multiple values into multiple tables in a single statement. The output… Read More
QUESTION: Consider the following table ITEM given below, write the commands in SQL for 1 – 10 and output for 11 – 20    … Read More
Overview :You will be able to understand the implementation to Find the Year from Date in SQL with the help of an example. Here we… Read More
The LEFT JOIN keyword in SQL returns the all matching records(or rows) and the records(or rows) that are present in the left table but not… Read More
In this article, we are going to see how we can compare the rows and columns of the same table in SQL. We will be… Read More
The RIGHT JOIN keyword in SQL returns the all matching records(or rows) and the records(or rows) which are present in the right table but not… Read More
In this article, we will discuss the overview of SQL Query to Calculate the Number of Months between two specific dates and will implement with… Read More