Filter interviews by
Top trending discussions
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
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.
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
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 6 reviews
Rating in categories
Senior NON Commissioned Officer
245
salaries
| ₹4.4 L/yr - ₹16.8 L/yr |
Junior Warrant Officer
230
salaries
| ₹4.2 L/yr - ₹15 L/yr |
Sergeant
226
salaries
| ₹5.5 L/yr - ₹18 L/yr |
Warrant Officer
112
salaries
| ₹5.6 L/yr - ₹18 L/yr |
Defence
110
salaries
| ₹5 L/yr - ₹15 L/yr |
Indian Army
Indian Navy
Border Security Force
Central Reserve Police Force