Skip to content

Category Archives: SQL

In relational databases, we often deal with different tables and perform various operations using this different database software like MYSQL, Oracle, PostgreSQL, etc. Sometimes, while… Read More
SQL stands for Structured Query Language. It is used for storing data in databases, modifying or manipulating data in databases and retrieving data from databases.… Read More
Here we will see, how to convert NUMERIC data to NVARCHAR data in a MS SQL Server’s database table using the CAST(), CONVERT() and FORMAT()… Read More
SQL language is a DML in DBMS. This is used to manipulate databases and the records kept in them. A database is a collection of… Read More
The word NULL is used to describe a missing value in SQL. In a table, a NULL value is a value in a field that… Read More
Web SQL is a web page API for storing or managing the data in databases that can be queried using a variant of SQL like… Read More
Here, we are going to  Get a Financial Year Using a Given Date in SQL. In this article, we will be making use of the… Read More
In SQL, we have databases that contain tables where our data is present. If we want to select some data from this table then we… 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