Filter interviews by
Pagination and searching in PHP involves dividing content into pages and implementing search functionality.
Use SQL queries with LIMIT and OFFSET for pagination.
Implement search functionality using SQL queries with WHERE clause.
Use PHP frameworks like Laravel for easier pagination and searching implementation.
To find the second highest salary in a table, we can use a SQL query with the MAX function and a subquery.
Use a SQL query with the MAX function to find the highest salary in the table.
Use a subquery to exclude the highest salary and find the second highest salary.
Example: SELECT MAX(salary) FROM employees WHERE salary < (SELECT MAX(salary) FROM employees);
Top trending discussions
posted on 16 Sep 2021
I appeared for an interview before Sep 2020.
Round duration - 70 Minutes
Round difficulty - Hard
Prateek is a kindergarten teacher with a mission to distribute candies to students based on their performance. Each student must get at least one candy, and if two s...
The task is to distribute candies to students based on their performance while minimizing the total candies distributed.
Create an array to store the minimum candies required for each student.
Iterate through the students' ratings array to determine the minimum candies needed based on the adjacent ratings.
Consider both left-to-right and right-to-left passes to ensure fair distribution.
Keep track of the total candies dist
You are given a sequence of numbers, ARR
. Your task is to return a sorted sequence of ARR
in non-descending order using the Merge Sort algorithm.
The Merge Sort...
Implement Merge Sort algorithm to sort a sequence of numbers in non-descending order.
Use Divide and Conquer approach to recursively divide the input array into two halves.
Merge the sorted halves to produce a completely sorted array.
Ensure the implementation handles the constraints specified in the problem statement.
Example: For input [3, 1, 4, 1, 5], the output should be [1, 1, 3, 4, 5].
Tip 1 : Practice Atleast 250 Questions
Tip 2 : Do atleast 2 projects
Tip 1 : Do not put false things on resume.
Tip 2 : Have some projects on resume.
I applied via Company Website and was interviewed in Jul 2021. There was 1 interview round.
Complex SQL scenarios and their results
Using subqueries to filter data
Joining multiple tables with complex conditions
Using window functions to calculate running totals
Pivoting data to transform rows into columns
Using recursive queries to traverse hierarchical data
I applied via Naukri.com and was interviewed before Nov 2021. There were 2 interview rounds.
I applied via Walk-in and was interviewed before Mar 2021. There were 3 interview rounds.
Aptitude test
Current affairs
posted on 15 Jul 2022
I applied via Referral and was interviewed before Jul 2021. There were 3 interview rounds.
If you are a fresher , then this is for you else almost no coding test for experienced candidates.
posted on 10 May 2020
I applied via Recruitment Consultant and was interviewed in Apr 2020. There were 4 interview rounds.
I applied via Naukri.com and was interviewed before Apr 2021. There were 2 interview rounds.
based on 3 interviews
Interview experience
based on 34 reviews
Rating in categories
Software Engineer
28
salaries
| ₹2 L/yr - ₹7.5 L/yr |
Senior Software Engineer
16
salaries
| ₹4.5 L/yr - ₹10.3 L/yr |
Software Developer
12
salaries
| ₹2 L/yr - ₹5 L/yr |
Digital Marketing Executive
8
salaries
| ₹1.2 L/yr - ₹5.5 L/yr |
Web Designer
8
salaries
| ₹1 L/yr - ₹5.7 L/yr |
Maxgen Technologies
Value Point Systems
JoulestoWatts Business Solutions
F1 Info Solutions and Services