Skip to content

Category Archives: SQL

In this article, we will discuss the overview of DDL commands and will understand DDL commands like create, alter, truncate, drop. We will cover each… Read More
SEQUEL widely known as SQL (Structured Query Language), is the most popular standard language to work on databases. It is a domain-specific language that is… Read More
RANDOM( ) in SQL is generally used to return a random row from a table present in the database. It has many applications in real… Read More
In this article we are going to study the SELECT FIRST commands in SQL, as we all know that there is already a command for… Read More
Keys are an important part of any Relational Database. There are various types of keys and among one of these is the Alternate Key. The… Read More
Here, we are going to see how to find the names of the persons other than a person with a particular name  SQL. In this… Read More
An SQL query is a single line statement of a Program written in a particular language to perform a specific task. A query consists of… Read More
In MySQL date is a data type and by default follows the format ‘YYYY-MM-DD’ but by using date formatting functions we can format date and… Read More
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
In this article, we will discuss the overview of SQL and will mainly focus on Concepts and Queries and will understand each with the help… Read More
SEQUEL widely known as SQL, Structured Query Language is the most popular standard language to work on databases. It is a domain-specific language that is… Read More
Here we will see, how to calculate the number of weeks between the two given dates with the help of SQL query using DATEDIFF() function.… Read More
Here we will see, how to calculate the number of days between the two given dates with the help of SQL query using DATEDIFF() function.… Read More
Here we will see, how to convert FLOAT data to NVARCHAR data in an MS SQL Server’s database table using the CAST(), CONVERT(), and FORMAT()… Read More