41
SQL Server Interview
SELECT, Filtering, Sorting & Built-in Functions
SQL Server interview questions covering select, filtering, sorting & built-in functions.
20 Questions Filter by level
Interview questions
Open a question for the full answer, code and interview guidance.
42
Why should SELECT * usually be avoided in production queries?
43
What is the WHERE clause?
44
What are comparison operators in SQL Server?
45
What are AND, OR, and NOT operators?
46
What is the BETWEEN operator?
47
What is the IN operator?
48
What is LIKE used for?
49
What is the difference between % and _ wildcards in LIKE?
50
How do you correctly filter NULL values?
51
What is ORDER BY?
52
What is DISTINCT?
53
What is TOP in SQL Server?
54
How is pagination implemented with OFFSET and FETCH?
55
What is an alias in SQL Server?
56
What is CASE in SQL Server?
57
What is ISNULL() and how is it used?
58
What is the difference between ISNULL() and COALESCE()?
59
What are common string functions in SQL Server?
60