In this article I will show Set 01 of 10 SQL Telephone Interview questions Advanced level and that should take less than 10 minutes!
IMPORTANT: Those are advanced SQL questions based on my experience so this set of question may inaccurately assess someone knowledge and I strongly suggest to replace some questions with questions that are relevant to your project.
What may happen if you use this value '2012-09-12' to filter date field in WHERE and login language is set to British.
Why having consistent collation is important when you use joins?
You have to return truly random 5 rows from a table. You have SELECT TOP 5 and which function would you use in ORDER BY to get truly random rows.
You have orders table with customers that placed more than one order. You need to show only records that represent customer most recent order. Which T-SQL functions can you use to achieve it?
How can you create a recursive query?
Which SQL Clause allows to use WITH CUBE?
Your query contains SELECT DISTINCT can you still use aggregate function (without sub-query) if yes how?
Why shouldn't you use CAST on a field in WHERE clause?
Can you refer to "previous row" using T-SQL?
How to calculate 70th Percentile of salary from Employee table using T-SQL.
I hope that helps