Let’s dive into the Top 10 SQL window function queries that you must know.
Saturday, July 19, 2025
Top 10 SQL Queries from Technical Interviews to Learn Window Functions like ROW_NUMBER
Hello guys, If you're preparing for SQL interviews or working on real-world reporting tasks, mastering window functions is no longer optional. They are one of the most powerful tools in SQL which allows you to perform calculations across rows related to the current row without collapsing your result set like GROUP BY does. Window functions like ROW_NUMBER(), RANK(), LEAD(), LAG(), and SUM() OVER help you write cleaner, faster, and more expressive queries—ideal for performance tuning and analytical processing.
Labels:
Microsoft SQL Server
,
SQL
,
SQL Interview Questions
Thursday, October 3, 2024
How to replace NULL with Empty String in SQL Server? ISNULL() vs COALESCE() Examples
We often need to replace NULL values with empty String or blank in SQL e.g. while concatenating String. In SQL Server, when you concatenate a NULL String with another non-null String the result is NULL, which means you lose the information you already have. To prevent this, you can replace NULL with empty String while concatenating. There are two ways to replace NULL with blank values in SQL Server, function ISNULL(), and COALESCE(). Both functions replace the value you provide when the argument is NULL like ISNULL(column, '') will return empty String if the column value is NULL.
Labels:
Microsoft SQL Server
,
SQL
,
SQL Interview Questions
Wednesday, October 2, 2024
Difference between char, varchar, nchar and nvarchar data types in SQL Server? Example
What is the difference between char and varchar in SQL, followed by nchar and nvarchar, is one of the popular SQL interview questions, and surprisingly not every programmer knows this basic difference. If you go with the name, which you should, then you can figure out that char is a fixed-length data type while varchar should be a variable-length data type. Though all char, varchar, nchar, and nvarchar are used to store text or String data there are subtle differences between them. As I said char is fixed length, which means a variable or a column like Zipcode char(10) will take only 10 bytes to store data, including space.
Subscribe to:
Posts
(
Atom
)