i
Crisil
Filter interviews by
I applied via Campus Placement and was interviewed in Apr 2024. There were 2 interview rounds.
Retrieve the third highest salary from an employee table using SQL queries.
Use the DISTINCT keyword to avoid duplicate salaries.
Utilize the ORDER BY clause to sort salaries in descending order.
Use the LIMIT clause to restrict the number of results returned.
Example SQL query: SELECT DISTINCT salary FROM employee ORDER BY salary DESC LIMIT 2, 1;
I applied via Naukri.com and was interviewed before May 2023. There was 1 interview round.
I applied via Naukri.com and was interviewed in Sep 2022. There were 3 interview rounds.
I applied via Campus Placement and was interviewed before Dec 2022. There were 3 interview rounds.
Basic concepts of programming
I applied via Naukri.com and was interviewed in Apr 2021. There were 3 interview rounds.
I applied via Approached by Company and was interviewed before Jul 2021. There was 1 interview round.
To write a REST API from scratch, I would follow these steps:
Define the resources and endpoints
Choose a programming language and framework
Implement CRUD operations for each resource
Use HTTP methods and status codes correctly
Add authentication and authorization
Test the API using tools like Postman
Document the API using tools like Swagger
Top trending discussions
str.swapcase() returns a new string with all uppercase letters converted to lowercase and vice versa.
Usage: 'Hello World'.swapcase() returns 'hELLO wORLD'.
It affects only alphabetic characters; numbers and symbols remain unchanged.
This method does not modify the original string; it returns a new one.
Example: 'Python 3.8'.swapcase() results in 'pYTHON 3.8'.
I applied via Naukri.com and was interviewed in Mar 2024. There was 1 interview round.
based on 3 interview experiences
Difficulty level
Duration
based on 27 reviews
Rating in categories
Research Analyst
1k
salaries
| ₹8.4 L/yr - ₹15 L/yr |
Senior Research Analyst
861
salaries
| ₹11.2 L/yr - ₹20 L/yr |
Analyst
533
salaries
| ₹6 L/yr - ₹12 L/yr |
Credit Analyst
470
salaries
| ₹9 L/yr - ₹16 L/yr |
Manager
467
salaries
| ₹19.1 L/yr - ₹34.1 L/yr |
IKS Health
Indegene
Acuity Knowledge Partners
Baroda Global Shared Services