Tag Archives: self join

SQL Query to find employees with X Consecutive A Grades

One of my friend (Satya) asked a very interesting interview question during the Lunch today. Question is to write a SQL Query to find the employees who received Grade ‘A’ for 3 consecutive years. Self-join is the simple answer to … Continue reading

Posted in Productivity, SQL Query, SQL Server | Tagged , , , , , , | Leave a comment