In SQL, sometimes we need to search the column names in a table using the prefixes. For this article, we will be using the Microsoft… Read More
Tag Archives: SQL-Query
In this article, we will see the conversion of a BLOB to TEXT in MySQL. BLOB: It stands for Binary Large Object. It is a… Read More
In this article, we will see an SQL query to concatenate two-column into one with the existing column name. We can perform the above activity… Read More
In SQL, sometimes we need to select matching a certain condition from the table. We will use the SELECT command along with the WHERE clause… Read More
In SQL, sometimes we need to write a single query to update the values of all columns in a table. We will use the UPDATE… Read More
Many of the time we have to delete data based on the date. These dates can be some older dates. For this purpose, we can… Read More
In SQL, due to lack of data, we sometimes need to insert rows with NULL values in the tables. Here, the keyword NULL(without quotes) is… Read More
In SQL, problems require us to compare two columns for equality to achieve certain desired results. This can be achieved through the use of the… Read More
In SQL, we sometimes need to rename the constraints of a table. The whole process for doing the same is demonstrated below. For this article,… Read More
In SQL, sometimes we require to select individual columns from a table. For this, we use a specific kind of query shown in the below… Read More
WIDTH_BUCKET( ) is a mathematical function used in Oracle and PostgreSQL. As the name suggests width_bucket means dividing the histogram into equal width buckets, that… Read More
In SQL, certain words are reserved. These are called Keywords or Reserved Words. These words cannot be used as identifiers i.e. as column names in… Read More
In SQL, many times we are required to display all the rows of a table in which the entries having 0(zero) as an entry/value are… Read More
In this article, we will see, how to write the SQL Query to exclude records if it matches an entry in another table. We can… Read More
Stored Procedure is a saved SQL code. It is created to save time as we can use it again and again without writing the whole… Read More
Courses
