Ven Consulting Civil Engineer Interview Questions and Answers

Use SQL to retrieve the top 2 salaries from each department efficiently.

• Use a Common Table Expression (CTE) or a subquery to rank salaries within each department.

• Example SQL: WITH RankedSalaries AS (SELECT Department, Salary, ROW_NUMBER() OVER (PARTITION BY Department ORDER BY Salary DESC) AS Rank FROM Employees) SELECT Department, Salary FROM RankedSalaries WHERE Rank <= 2;

• This method ensures you get the top salari...read more

Use a combination of backup and delete approach to safely delete the records.

• Take a backup of the live system before deleting any records.

• Identify the records to be deleted using a query or script.

• Delete the records in batches to avoid overwhelming the system.

• Monitor the system during the deletion process for any issues.

• Verify the deletion by checking the number of records before and after.

• Consider archiving the delete...read more