#window

Write an SQL query to find the second-highest salary from an employee table.

Demonstrate the difference between DENSE_RANK() and RANK()

Discuss differences between ROW_NUMBER(), RANK(), and DENSE_RANK(), and provide examples from your projects.

Explain the types of triggers in ADF, including schedule, tumbling window, and event-based triggers.

Joins and window functions - INNER, LEFT, RIGHT, FULL OUTER, ROW_NUMBER(), RANK(), DENSE_RANK()

How do you handle late-arriving data in Spark Structured Streaming?

Briefly explain the architecture of Kafka.

Retrieve the most recent sale_timestamp for each product (Latest Transaction).

Explain SQL Window Functions with examples.

Implement a query to find the top 5 customers by total sales amount.

SQL query to find the second highest salary from each department.

Write an SQL query to find duplicate emails in a users table.

Triggers in ADF, especially tumbling window triggers.

What is a window function? Explain with an example.