---
title: "Kailas Warade (@sankalandtech) | Hashnode"
description: "Programming and Data Analytics Simplified For Everyone. Read the latest articles by Kailas Warade on Hashnode."
url: "https://hashnode.com/@sankalandtech"
---

@sankalandtech

# Kailas Warade

@sankalandtech · Joined March 2025

Programming and Data Analytics Simplified For Everyone

[Website](https://www.sankalandtech.com/)

### [SQL Challenge Compare Today's Sales With Yesterday's Sales Using LAG() in Oracle SQL](https://sankalandtech.hashnode.dev/sql-challenge-compare-today-s-sales-with-yesterday-s-sales-using-lag-in-oracle-sql?utm_source=hashnode&utm_medium=feed)

When working with sales data, looking at daily revenue alone doesn't always tell the complete story. Sometimes, businesses need to compare today's sales with the previous day's sales to understand w

4 min read · [sankalandtech.hashnode.dev](https://sankalandtech.hashnode.dev/sql-challenge-compare-today-s-sales-with-yesterday-s-sales-using-lag-in-oracle-sql?utm_source=hashnode&utm_medium=feed)

[7h ago](https://hashnode.com/posts/sql-challenge-compare-today-s-sales-with-yesterday-s-sales-using-lag-in-oracle-sql/6affbb692be3bf50cc845c7e)

### [SQL Running Total Using SUM() OVER() in Oracle SQL – Practical Example](https://sankalandtech.hashnode.dev/sql-running-total-using-sum-over-in-oracle-sql-practical-example?utm_source=hashnode&utm_medium=feed)

When working with sales data, sometimes we need more than just the total sales for a particular day. For example, imagine your manager asks you to prepare a report showing daily sales along with the t

3 min read · [sankalandtech.hashnode.dev](https://sankalandtech.hashnode.dev/sql-running-total-using-sum-over-in-oracle-sql-practical-example?utm_source=hashnode&utm_medium=feed)

[1d ago](https://hashnode.com/posts/sql-running-total-using-sum-over-in-oracle-sql-practical-example/6afe8009240017d48ac31edd)

### [SQL Challenge : Find the Second Purchase of Every Customer Using ROW\_NUMBER()](https://sankalandtech.hashnode.dev/sql-challenge-find-the-second-purchase-of-every-customer-using-row-number?utm_source=hashnode&utm_medium=feed)

In real-world applications, businesses often need to track customer purchase history. One common requirement is finding the second order placed by each customer. This information can help businesses

3 min read · [sankalandtech.hashnode.dev](https://sankalandtech.hashnode.dev/sql-challenge-find-the-second-purchase-of-every-customer-using-row-number?utm_source=hashnode&utm_medium=feed)

[2d ago](https://hashnode.com/posts/sql-challenge-find-the-second-purchase-of-every-customer-using-row-number/6afd1eb0db27c2391ecb6a11)

### [SQL Challenge #103: Find the Top 2 Highest-Paid Employees in Every Department Using ROW\_NUMBER()](https://sankalandtech.hashnode.dev/sql-challenge-103-find-the-top-2-highest-paid-employees-in-every-department-using-row-number?utm_source=hashnode&utm_medium=feed)

Window functions are very useful in SQL interviews and real-world data analysis. They help us rank records, compare values and solve problems that are difficult to handle with basic aggregate function

4 min read · [sankalandtech.hashnode.dev](https://sankalandtech.hashnode.dev/sql-challenge-103-find-the-top-2-highest-paid-employees-in-every-department-using-row-number?utm_source=hashnode&utm_medium=feed)

[3d ago](https://hashnode.com/posts/sql-challenge-103-find-the-top-2-highest-paid-employees-in-every-department-using-row-number/6afbc5f12864dcc1bec41700)

### [SQL Challenge : ROW\_NUMBER() vs RANK() vs DENSE\_RANK() – What's the Difference?](https://sankalandtech.hashnode.dev/sql-challenge-row-number-vs-rank-vs-dense-rank-what-s-the-difference?utm_source=hashnode&utm_medium=feed)

SQL window functions are useful when working with employee rankings, sales reports and business data. Three commonly used ranking functions are "ROW\_NUMBER()", "RANK()" and "DENSE\_RANK()". Although th

2 min read · [sankalandtech.hashnode.dev](https://sankalandtech.hashnode.dev/sql-challenge-row-number-vs-rank-vs-dense-rank-what-s-the-difference?utm_source=hashnode&utm_medium=feed)

[4d ago](https://hashnode.com/posts/sql-challenge-row-number-vs-rank-vs-dense-rank-what-s-the-difference/6afa7f00662d9369ba345a65)
