Tag Archives: DBMS-SQL

SQL Inner Join

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

DBMS-SQL

Picked

SQL

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

DBMS-SQL

SQL

How to compare columns in two different tables in SQL

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

DBMS-SQL

Picked

SQL

Joining 4 Tables in SQL

Expert

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

DBMS-SQL

Picked

SQL

SQL Query to Add Unique key Constraints Using ALTER Command

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

DBMS-SQL

Picked

SQL

SQL Query to select Data from Tables Using Join and Where

Expert

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

Calculate Running Total in SQL

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

DBMS-SQL

SQL

List the available Databases for Current User in SQL SERVER

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

DBMS-SQL

SQL-Server

SQL

Insert multiple values into multiple tables using a single statement in SQL Server

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

DBMS-SQL

DBMS

SQL

SQL Query to Find the Year from Date

Basic

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

DBMS-SQL

DBMS

SQL

How to Compare Rows and Columns in the Same Table in SQL

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

DBMS-SQL

DBMS

SQL

Calculate the Number of Months between two specific dates in SQL

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

DBMS-SQL

Picked

SQL