In some situations, we need to get an overview of the data present in a table. Or perhaps we want to check if there are any duplicate values in...
What I have here today is a article for beginners. It will be full of sql query examples. We will start from the most basic ones and continue up....
The error message “Conversion failed when converting the varchar value to data type int” occurs in SQL Server when attempting to convert a value stored as the varchar (text)...
In one of our previous articles, we tried to see how to get data from Excel into an SQL table (Import Excel to SQL Database). Now, we will show...
This mini-article is made for beginners. We will take a closer look on how to write a simple T-SQL script and I will also explain basic sql commands. We...
GROUP BY clause is used to group data. In most of the cases, we talk of a situation when we need to make an aggregate operation in the table...
HAVING clause is a special type of SQL command. It works in a similar way as WHERE clause and we use it to define a condition. There are important...
ORDER BY clause in SQL enables us to sort results of the query by specific field (column) or more columns. There are 2 sorting options: Ascending order (ASC) –...
WHERE clause is used to define limit requirements for queries. We are not interested in all records in most cases of queries into tables. Only some subsets of the...
When you work with SQL database you usually need more than 1 table. Some values are in one table and the others are in a different one = division...
When you work with SQL database you usually need more than 1 table. Some values are in one table and the others are in a different one = division...
When you work with SQL database you usually need more than 1 table. Some values are in one table and the others are in a different one = distribution...
When we work with SQL database we usually need to work with more than 1 table. Some values are in one table and the others are in a different...
SELECT clause is used to gain data from a table. This clause is followed by a list of columns, which we need to display. This clause must always be...