Solugenix India Private Limited Technical Analyst Interview Questions and Answers

The answer to the question is to perform a join operation on the table to retrieve the manager name with respective employee name.

• Use a SQL query to join the table on the manager ID

• Select the manager name and employee name from the joined table

• Display the manager name with respective employee name

To find the 3rd highest salary of any Employee from a table, we can use the SQL query with the 'ORDER BY' and 'LIMIT' clauses.

• Write an SQL query to select the distinct salaries from the table in descending order.

• Use the 'LIMIT' clause to limit the result to the third row.

• The selected salary will be the 3rd highest salary of any employee.