Vivek

Comments

Post a Comment

Popular posts from this blog

top 2 from table

SQL Query: Fetch Top 2 Records by Salary Fetch Top 2 Records from a Table 🧩 Problem Statement: You are given access to a table named Employees , which contains employee details. Your task is to write a query to fetch the top 2 records from the table based on their Salary in descending order. If two or more employees have the same salary, prioritize by EmployeeID in ascending order. 📋 Sample Input Table: Employees EmployeeID Name Department Salary 101 Abhay HR 60000 102 aditya IT 75000 103 Vivek Finance 72000 104 Shubham IT 75000 105 Pradeep HR 58000 ✅ Sample Output EmployeeID Name Department Salary 102 aditya IT 75000 104 Shubham IT 75000 💡 SQL Query (Approach 1 & 2)...
Read more

Diamond problem in CPP

  Diamond problem explained The basic scenario a . Suppose P is the base class. b .Class Q and R inherits from class P. c. Class S inherits from both Q and R. Now, if P  has a member (like a variable or function), and S  tries to access it, ambiguity arises: should it use the version inherited via Q  or the one via R ? CPP Program: #include <iostream> using namespace std; class A { public:     void show() { cout << "A::show" << endl; } }; class B : public A { }; class C : public A { }; class D : public B, public C { }; int main() {     D obj;     obj.show(); // ❌ Error: request is ambiguous     } How we will solve it: C++ solve this problem using virtual function which ensures that only one copy of the base class is shared. Solved : #include <iostream> using namespace std; class A { public:     void show() { cout << "A::show" << endl; } }; class B : virtual public A { }; class C ...
Read more

Fetch Top 2 Records From Table

  Title:  Fetch Top 2 Records from a Table. Problem Statement :  You are given access to a table named Employees , which contains employee details. Your task is to write a query to fetch the top 2 records from the table based on their Salary in descending order . If two or more employees have the same salary, prioritize by EmployeeID in ascending order. Sample Input Table: Employees EmployeeID Name  Department Salary 101        Abhay    HR               60000 102       aditya    IT                      75000 103       Vivek         Finance           72000 104       Shubham    IT                      75000 105       Pradeep    H...
Read more