One of the very common business scenario in SQL is to find the record that exists in one table and does not exists in the other table. You can solve such questions in 4 different manners. Problem Statement You are […]
The most common method to fetch previous row value in SQL is by using the LAG function. The LAG function returns the previous row value. Depending on the order by clause the previous row is determined and the column value […]
Duplicate rows in the table can result in data quality issues. Sometimes it is ok to have duplicate rows in the table as per business requirement. However if the duplicate rows are loaded into the table accidentally you must remove […]
