Skip to content

Category Archives: 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
In this article, we are going to see how to find the average value in a column in SQL.  A column in the SQL table… Read More
In this article, we will look into the process of querying the sum of all values in a column of a database table. But before… Read More
Here, we are going to see how to find the shortest and longest string from a column of a table in a database with the… Read More
In this article, we are going to write an SQL query to count the number of rows in a table.  For is we will be… Read More
Here, we are going to see how to display the first 50% of records from an Employee Table in MS SQL server’s databases. For the… Read More
Here, we are going to see How to Drop a Foreign Key Constraint using ALTER Command(SQL Query) using  Microsoft SQL Server. A Foreign key is… Read More
Here, we are going to see how to display the last 50% of records from an Employee Table in MySQL and MS SQL server’s databases.… 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