Skip to content

Tag Archives: SQL-Query

Here, we are going to see how to find the SQL Query to check whether the date passed to query is the date of the… Read More
In this article, we will learn how we add an extra or a new parameter after a table is created using ALTER command in Microsoft… Read More
In most of the queries in the learning process, we usually use to join those tables which have some common columns or relationships between them.… Read More
In this article let us see how can we check for the validation of mails in the student database using MSSQL as the database server.… Read More
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
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
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
COUNTIF function in excel is used to count the number of cells that match a single condition applied. It can include Dates, Numbers, and Texts.… 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
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