Khushhali Microfinance Bank interview questions

How to remove duplicates from the table using SQL Query? How to get 3rd highest Salary from Table using SQL by not using Window Functions ? What was the most difficult scenario you faced yet in the domain ? Can you tell us about Customer KPIs? Can you have knowledge of T24 System, how it works and etc. ? What is Surrogate key ? What is Fact and Dim in the EDWH ? Type of both of them ?