Hello friends! Today we’ll be learning different methods to find unique values in SQL. When working with large datasets in SQL, it is often essential to find unique values for analysis or reporting purposes. Thankfully, SQL provides several approaches to identify distinct or unique values within a column or a dataset.
Read moreHello friends! Today we’ll be learning how to concatenate text from multiple rows into a single text string and vice versa. Easy to follow code attached in the tutorial. When working with large datasets in SQL Server, it’s common to need to combine text from multiple rows into a single text string. This can be useful for creating reports, generating email notifications, or creating custom messages for users. In this blog post, we’ll explore some techniques for concatenating text from multiple rows in SQL Server.
Read moreHello Friends, this blogpost will be different from other blog posts and there will be no tutorials but I’ll share the sources from which you can make money as technical writer. Some of the sites pay up to $1000 per article depending on the quality and views.
Read moreHello friends!! I have created the learning path for data science tools. It covers almost all the topics to start with the tool and become comfortable in it. Check the data science learning path below.
Read moreHello friends! It is estimated to have 11,000,000+ job openings in Data Science industry by 2026 globally.
Building is portfolio to stand out is absolutely necessary. Here are few tips to build your Data science portfolio but can be applicable to any other tech profile.
Read moreSQL is an amazing tool, if we know to use it the right way. Using the concept of the SQL server spatial data and some mathematics, I have built this Christmas tree the SQL way!!. Attached is the image of the output. The code is as below. You too can run the code for yourself and generate the tree.
Note: After Executing the code, to see the image, Click on the “Spatial results” tab below in the results window, Uncheck the ‘Show Grid lines’ box in the right pane. You will be able to see the image.
Read more
Values() clause also known as Table valued Constructor(TVC) was introduced in SQL server 2008. This is a very useful clause and has variety of applications. One such application we will be looking here is to create a matrix of numbers and then display the sum of numbers and maximum values in each row of the matrix using values() clause. SQL code is as below:
The INSERT statement in SQL allows you to add data to a table. Let’s take a look at it and see some examples in this article.
