Interview Questions

Delete duplicate rows in sql Server We will discuss deleting all duplicate rows except one from a sql server table. Let me explain what we want to achieve. We will…

How does a recursive CTE work in Sql Server How a recursive CTE work line by line. SQL Server Interview questions and answers video series we discussed recursive CTE to…

SQL query to get organization hierarchy in SQL Server To get the best out of this blog, the following concepts need to be understood first.1. Self-Join2. CTE3. Recursive CTE Here…

How to find nth highest salary in sql Server This is a very common SQL Server Interview Question. There are several ways of finding the nth highest salary. By the…

1.How to pass data from parent to child or child to parent. Ans-Parent to child: Data can be passed from a parent component to a child component by using input…

Web API Basics In the description box, you can find a list of all the questions related to the topic of Web API. The initial focus is on basic questions…

Why do we need object oreinted programming ? object oreinted programming helps us to think, in terms of real world objects. Let us try to understand this statement thinking in…

What is SOLID Principle? What is Liskov ? Difference between Interface and Abstract class in C#? When and How to use Virtual keyword? What is runtime or compile time Polymorphism?…

Creational Design Patterns: As the name suggests, this design provide mechanism of various object creation which reuse of exsting code and increase flexibility. .Abstarct factory,Builder,Factory Method,Prototype,Singleton. Structural Design patterns: As…

SOLID principles are the design principles that enable us manage most of the software design problems. The term SOLID is an acronym for five design principles intended to make software…