Skip to content

Category Archives: SQL

In this article, we will see the use of IN Operator with a SubQuery in SQL. IN operator is used to compare the column values… Read More
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
SQL logical operators are used to test for the truth of the condition. A logical operator like the Comparison operator returns a boolean value of… Read More
Here we will see, how to export SQL Server Data to CSV file by using the ‘Import and Export wizard’ of SQL Server Management Studio… Read More
In this article, we will see how to use GROUP BY to count the number of rows for each unique entry in a given table.… Read More
In this article, we will see how to use NULL values inside NOT IN Clause in SQL. NULL has a special status in SQL. It… Read More
Here we will see, how to read a text file with SQL Server. We can read the text file using the OPENROWSET(BULK ) function. OPENROWSET(BULK)… Read More
Here we will see, how to escape square brackets in a LIKE clause. LIKE clause used for pattern matching in SQL using wildcard operators like… Read More
In this article, we will see how to use CASE in the ORDER BY clause to sort records by the lowest value of 2 columns… Read More
A Database is defined as a structured form of data that is stored database a computer or data in an organized manner and can be… Read More
There can be many columns in a database table, so sometimes it can become difficult and time taking to find the same type of data… 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