SQL Query: Delete Duplicates from a table
Question We need to remove the duplicate rows of data from our database. Data For this exercise, I have created dummy data. The SQL file …
Category: SQL Exercise
Contains various SQL exercises and their solution
SQL Exercise: Let’s practice Performing a Full-Text Search
In this exercise, I will be using AdventureWorks 2008 Database and will write my SQL queries using SSMS 18. All the exercises are from the …
SQL Exercise: Let’s practice Working with Nothing
In this exercise, I will be using AdventureWorks 2008 Database and will write my SQL queries using SSMS 18. All the exercises are from the …
SQL Exercise: Let’s practice Filtering with Multiple Predicates
In this exercise, I will be using AdventureWorks 2008 Database and will write my SQL queries using SSMS 18. All the exercises are from the …
SQL Exercise: Let’s practice Filtering with Wildcards
In this exercise, I will be using AdventureWorks 2008 Database and will write my SQL queries using SSMS 18. All the exercises are from the …
SQL Exercise: Let’s practice Filtering Data
In this exercise, I will be using AdventureWorks 2008 Database and will write my SQL queries using SSMS 18. All the exercises are from the …