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
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
An SQL join statement is used to combine rows or information from two or more than two tables on the basis of a common attribute… Read More
Here, we are going to see how to query multiple tables in SQL.  For example, here, we will first create a database named “geeks” then… Read More
Here, we are going to see how to Compare Time in SQL Server. In this article, we will be making use of the Microsoft SQL… Read More
Here we will see, how to filter rows without null in a column of an MS SQL Server’s database table with the help of a… Read More
Query in SQL is like a statement that performs a task. Here, we need to write a query that will find the number of employees… Read More
Query in SQL is like a statement that performs a task. Here, we need to write a query to find all the students whose marks… Read More
Here, we see how to drop unique constraints using alter command. ALTER is used to add, delete/drop or modify columns in the existing table. It… Read More
Here we are going to see how to retrieve unique (distinct) records from a Microsoft SQL Server’s database table without using the DISTINCT clause. We… Read More
In this article, we will look into how you can add a foreign key constraint using the ALTER command in SQL. For this article, we… Read More
Query in SQL is like a statement that performs a task. Here, we need to write a query that will print the name of the… Read More
In this article, we are going to see how to store JSON data into MySQL database using PHP through the XAMPP server. Requirements: XAMPP Server… Read More
SQL stands for Structured Query Language, which used in the database to retrieve data, update and modify data in relational databases like MySql, Oracle, etc.… Read More