Tag Archives: sql query

Validate and delete duplicate records from MSSQL table

I had a situation where Index creation failed and business wants to delete duplicate entries immediately from a specific table. I had to validate the columns which are unique and which had different values. Following is easy script to validate … Continue reading

Posted in SQL, SQL Query, Uncategorized | Tagged , , , | Leave a comment

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