In this article I will show Set 01 of 10 SQL Telephone Interview questions Intermediate level and that should take less than 10 minutes!
This test covers intermedia level of SQL so are suitable for fairly experienced candidates and are based on SQL Server.
UNION with UNION ALL are T-SQL set operators. Give names of two other set operators.
What kind of function is DENSE_RANK?
Which ranking function would you use to create a calculated field that would split SQL results into 10 groups.
You have a table with ProductID field and values of one unique ProductID can appear multiple times in the table. Provide T-SQL query that will count unique ProductIDs in this table.
What is the name of T-SQL special clause that allows you to access affected rows and insert them into another location.
NOTE: MERGE is not a T-SQL Clause.
You need to return rows from a table where PostCode (UK PostCode to be precise) starts with b, c or d and third characters is a number between 1 and 8?
You have a table with one field and 5 rows which contains numbers. 5, 10, 15, NULL and 25. Provide SQL that will show average number but NULLs are replaced by default number 12. You are allowed to use only one calculated field in your query.
What is the name of T-SQL join that will return all related rows but also rows from left table that don't exist in right table AND rows from right table that don't exist in left table.
Provide T-SQL or logic that using GETDATE() Function returns last day of current month.
What does CTE stand for?
I hope that helps