KnowStar

SQL | How to find the most purchased items together?

SQL Query | How to find most frequently purchased together items In this tutorial, we write a SQL Query to find the most frequently purchased together items.Practice dataset and SQL statement is available here https://know...

How to write SQL Complex Queries?

How to write SQL Complex Queries | Practice with examples | Must do for Interviews In this video, we practice writing SQL Complex queries.Below are the SQL Queries with their timelines -1- Find employees with highest salary in a department ...

Learn the 3 ways in which you can perform UPSERT in SQL

https://youtu.be/3VO1AhrIz8M

SQL Query | 3 ways to perform Upsert | Update else Insert | EXISTS | ROWCOUNT | MERGE In this tutorial, we discuss 3 ways to perform Upsert Operations in SQL Server.Method 1 - EXISTSMethod 2 - ROWCOUNTMethod 3 - MergeThe SQL code for sample da...