Loading Company...
This is a verified interview question from Flipkart-grid-8.0. Candidates reporting seeing this problem in recent Online Assessments (OAs) and onsite rounds. Mastering "Second Highest Salary SQL - Flipkart Grid 8.0" covers key patterns like Other.
"Consider the five tables dept, emp, designation, compensation, and emp_dept as shown in the following ER Diagram.  The employer wants to know the second-highest salary paid to the employee in the month of January 2021. Can you help with a query to get emp_no, first_name, last_name, gender, dept_no, dept_name, and the salary credited in January 2021. Note: Table Names and column names should be in the same case (lower/uppercase/InitCap) given in question while writing SQL queries else it will create a syntax error. Expected Output Format Based on the sample output provided in the images, the result set should look like this (comma-separated if it were raw CSV, but standard columns for SQL):"
Join thousands of developers practicing for Flipkart-grid-8.0.