Engineer 1 Interview Questions

3,934 engineer 1 interview questions shared by candidates

You have a table called Orders with the following structure. Write an SQL query to find the second highest order amount from the table. How would you modify your query if there are duplicate order amounts and you still need the second highest unique amount?
avatar

SDE 1

Interviewed at MAQ Software

2.8
Mar 7, 2025

You have a table called Orders with the following structure. Write an SQL query to find the second highest order amount from the table. How would you modify your query if there are duplicate order amounts and you still need the second highest unique amount?

Screening round (1st round) Coding questions (Minimise tax, Maximize profit) Interview Round 1: DSA question: Skip-One Spiral Matrix Traversal, Problem Statement: Given a 2D matrix of integers, implement a function to traverse the matrix in a spiral order while skipping one element. Input: matrix = [ [1, 2, 3, 4], [5, 6, 7, 8], [9, 10, 11, 12] ] Output: [2, 4, 12, 10, 5, 7, 6, 9, 11, 8, 3, 1] 2 SQL queries: Given 2 tables (Teacher details, department table) Find the Experience of a teacher Find a teacher who has max experience from each dept Interview round 2: Generate power set Code for the puzzle Few managerial questions
avatar

Software Engineer 1

Interviewed at MAQ Software

2.8
May 4, 2024

Screening round (1st round) Coding questions (Minimise tax, Maximize profit) Interview Round 1: DSA question: Skip-One Spiral Matrix Traversal, Problem Statement: Given a 2D matrix of integers, implement a function to traverse the matrix in a spiral order while skipping one element. Input: matrix = [ [1, 2, 3, 4], [5, 6, 7, 8], [9, 10, 11, 12] ] Output: [2, 4, 12, 10, 5, 7, 6, 9, 11, 8, 3, 1] 2 SQL queries: Given 2 tables (Teacher details, department table) Find the Experience of a teacher Find a teacher who has max experience from each dept Interview round 2: Generate power set Code for the puzzle Few managerial questions

Viewing 1781 - 1790 interview questions

See Interview Questions for Similar Jobs

Glassdoor has 3,934 interview questions and reports from Engineer 1 interviews. Prepare for your interview. Get hired. Love your job.