Filter interviews by
I appeared for an interview before Mar 2024, where I was asked the following questions.
SQL Rank salary calculates employee salaries and ranks them within a dataset using SQL functions.
Use the RANK() function to assign a rank to each salary: RANK() OVER (ORDER BY salary DESC).
Ties in salary will receive the same rank, and the next rank will skip accordingly.
Example: If salaries are 5000, 6000, 6000, 7000, ranks will be 4, 2, 2, 1.
Use PARTITION BY to rank within specific groups, e.g., RANK() OVER (PARTITIO...
Calculate salary ranks using SQL to determine employee standings based on their salaries.
Use the RANK() function to assign ranks based on salary: SELECT name, salary, RANK() OVER (ORDER BY salary DESC) AS rank FROM employees;
Handle ties with DENSE_RANK() to avoid gaps in ranking: SELECT name, salary, DENSE_RANK() OVER (ORDER BY salary DESC) AS rank FROM employees;
Use PARTITION BY to rank within specific groups, e.g., b...
Top trending discussions
I applied via Campus Placement and was interviewed before Sep 2021. There were 2 interview rounds.
Mcqs on javascript,. 1 coding question
I appeared for an interview before Jun 2016.
posted on 6 Nov 2015
I applied via Recruitment Consultant and was interviewed before Oct 2020. There were 3 interview rounds.
I applied via Naukri.com and was interviewed in Oct 2021. There was 1 interview round.
I applied via Approached by Company and was interviewed before Jul 2022. There were 3 interview rounds.
I applied via Campus Placement and was interviewed in Jul 2024. There were 3 interview rounds.
Full c concept MCQ with IQ and Computaional Thinking
Number system conversion in C involves converting numbers between different bases, such as decimal to binary or hexadecimal.
Use functions like itoa() to convert integers to strings in different bases
Use strtol() to convert strings to integers in different bases
Remember to specify the base when converting numbers
I applied via Campus Placement and was interviewed before Apr 2023. There were 2 interview rounds.
Normal apptitude queations were asked in this round
I applied via Campus Placement and was interviewed before Oct 2023. There was 1 interview round.
based on 1 interview experience
Difficulty level
Duration
based on 1 review
Rating in categories
Talent Acquisition Executive
57
salaries
| ₹2 L/yr - ₹4 L/yr |
Information Technology Recruiter
52
salaries
| ₹1.5 L/yr - ₹4.2 L/yr |
Software Engineer
46
salaries
| ₹6 L/yr - ₹13 L/yr |
Software Developer
39
salaries
| ₹5.8 L/yr - ₹12 L/yr |
Senior Software Engineer
28
salaries
| ₹10.7 L/yr - ₹19.9 L/yr |
HCL Infosystems
Accel Frontline
Pitney Bowes
JMR Infotech