Comprehensive, community-driven list of essential SQL interview questions. Whether you're a candidate or interviewer, these interview questions will help prepare you for your next SQL interview ahead of time.
34. What are the NVL and the NVL2 Functions? How do They Differ? NVL(exp1, exp2)andNVL2(exp1, exp2, exp3)are functions that help us with null-checking problems. But there are some differences. As you can see the NVL function accepts 2 parameters, while the NVL2 function accepts 3 ...
21. What are Window Functions? Explain with an example. Answer: Window functionsperform calculations across a set of table rows that are related to the current row. Unlike regular aggregate functions, which return a single value for a group of rows, window functions return a value for each ro...
This query will return the string "Iabcllipaat". In this example, Stuff function replaces the string "Intellipaat" onwards the 3rd position('nte') with 'abc'.Replace Function : Replace function is used to replace all occurrence of a specified with the string passed as last argument....
49.SQL SQRT Functions 50.SQL RAND Function 51.SQL CONCAT Function 52.SQL Numeric Functions 53.SQL String Functions What’s New Version History 10 Mar 2025 Version 18.3 support iOS 18; more contents; App Privacy The developer,强马, indicated that the app’s privacy practices may include handli...
49.SQL SQRT Functions 50.SQL RAND Function 51.SQL CONCAT Function 52.SQL Numeric Functions 53.SQL String Functions What’s New Version History 10 Mar 2025 Version 18.3 support iOS 18; more contents; App Privacy The developer,强马, indicated that the app’s privacy practices may include handli...
REPLACE function() replaces all occurrences of a substring within a string, with a new substring.Syntax: REPLACE[string, old_string, new_string]Example: SELECT REPLACE['ABC ABC ABC', 'a', 'c']; returns cBC cBC cBC.https://www.w3schools.com/sql/sql_ref_sqlserver.aspDay08) What is ...
(or, as described below, the direction of the search), the position returned by INSTR and the other string-index search functions described here is always based on the substring’s position in the string itself, starting at the beginning of the string, and not its position in relation to ...
Focus areas: Advanced SQL functions, window functions, triggers, stored procedures, and advanced performance optimization techniques. Resources: Advanced courses, real-world projects, and professional mentoring. Outcome: Proficiency in SQL suitable for more specialized roles such as database administrator,...
DataLemurhas a curated collection of SQL interview questions that have appeared in interviews in tech companies like LinkedIn, Tesla, Microsoft, and Walmart among others. The platform has over 40 SQL interview questions on topics such as conditional aggregation, string and window functions, and cumu...