Skip to content

Tag Archives: SQL-Query

In this article, we will see, how to delete certain rows based on comparisons with other tables. We can perform the function by using a… Read More
Here we will see, how to remove the last characters from a table in SQL. We can do this task using the SUBSTRING() function. SUBSTRING():… Read More
In this article, we will see SQL Query to Compare results with Today’s date by comparing the data with today’s date using GETDATE() function of… Read More
In this article, we will look at how to convert Date to Datetime. We can convert the Date into Datetime in two ways.  Using CONVERT()… Read More
The Update statement is a SQL keyword to update data in the database. We can update all the rows in the database or some values… Read More
SQL stands for Structured Query Language. It is a language used to interact with the database, i.e to create a database, to create a table… Read More
To display the length and first three characters of a string, string functions come in handy to do these in SQL. In this article let… Read More
In SQL Server, a Boolean Datatype can be created by means of keeping BIT datatype. Though it is a numeric datatype, it can accept either… Read More
In this article, we will see an SQL query to check if a name begins and ends with a vowel and we will implement it… Read More
To display the top 5 selling products ORDER BY can be used with the  SELECT TOP clause. So let us see the SQL Query for… Read More
ALTER SQL command is a DDL (Data Definition Language) statement. ALTER is used to update the structure of the table in the database (like add,… Read More
The primary key is the key that may contain one or more columns that uniquely identify each row in a table. We can add a… Read More
In order to find the highest purchase amount of each customer, we can use the GROUP BY clause which is very useful with aggregate functions.… Read More
Here we will see, how to remove the first characters of a specific column in a table in SQL. We can do this task using… Read More
In this article, we will look at how to remove trailing spaces. Trailing spaces means the space characters from the right side. We need to… Read More