Rajanand Ilangovan
Rajanand Ilangovan

Rajanand Ilangovan

Series

Scenario based SQL Interview questions and answers

In this series, I will post scenario based practical questions and answers to prepare for beginner to advanced level SQL interviews.

Articles in this series

How to concatenate multiple rows into a single string in SQL?

May 16, 20222 min read

SQL interview questions and answers #11 · Write a SQL query to concatenate multiple rows into a single string? USE TestDB; GO DROP TABLE IF EXISTS...

How to concatenate multiple rows into a single string in SQL?

How to de-group the data in SQL?

May 15, 20221 min read

SQL interview questions and answers #10 · Write a SQL query to de-group the data and provide the output as below. Let us first create the test data to...

How to de-group the data in SQL?

How to find the missing numbers in a series?

May 1, 20221 min read

SQL interview questions and answers #9 · To demonstrate this, we will first create a test data number sequence from 1 to 25 with some missing numbers in...

How to find the missing numbers in a series?

How to concatenate values from previous row to current row in SQL?

Apr 9, 20221 min read

SQL interview questions and answers #8 · Answer: DECLARE @t TABLE ( id INT IDENTITY(1,1) PRIMARY key, drink_name VARCHAR(30) ) INSERT INTO @t...

How to concatenate values from previous row to current row in SQL?

How to swap column value in SQL?

Mar 30, 20221 min read

SQL interview questions and answers #7 · Question: Write an update statement to swap the column values without using a temporary tables. Before Update:...

How to swap column value in SQL?

How to get nth highest salary in SQL Server?

Mar 9, 20224 min read

SQL interview questions and answers #6 · You have an employee table with employee details. You need to get 3rd highest salary get the employee details...

How to get nth highest salary in SQL Server?