Filter interviews by
I applied via Newspaper Ad and was interviewed before Mar 2023. There were 3 interview rounds.
To be positive and focused
Latest topics. Indepth knowledge is required. Command over language.
Task performance. Physical tests
Top trending discussions
To find the 3rd highest salary in a database, we can use a SQL query with the ORDER BY and LIMIT clauses.
Write a SQL query to select distinct salaries from the database table.
Use the ORDER BY clause to sort the salaries in descending order.
Add the LIMIT 2,1 clause to skip the first two highest salaries and select the third highest salary.
Execute the query to retrieve the 3rd highest salary from the database.
posted on 12 Sep 2021
I was interviewed in Aug 2021.
Convert top 10 records from a pandas dataframe to a Python dictionary.
Use the pandas `head()` method to get the top 10 records of the dataframe.
Use the `to_dict()` method to convert the dataframe to a dictionary.
Pass the `orient` parameter as 'records' to get a list of dictionaries.
Use list slicing to get the top 10 records from the list of dictionaries.
Interview experience
based on 10 reviews
Rating in categories
Colonel
345
salaries
| ₹20.8 L/yr - ₹50 L/yr |
Army Junior Commission Officer
339
salaries
| ₹4 L/yr - ₹15 L/yr |
Army
319
salaries
| ₹2.3 L/yr - ₹10 L/yr |
Executive Army
292
salaries
| ₹2 L/yr - ₹10 L/yr |
Army Officer
259
salaries
| ₹14.4 L/yr - ₹30.3 L/yr |
Indian Air Force
Indian Navy
Border Security Force
Central Reserve Police Force