Filter interviews by
I applied via Referral and was interviewed in Jul 2023. There were 2 interview rounds.
row_number(), rank(), and dense_rank() are SQL functions used for ranking and ordering data.
row_number() assigns a unique number to each row in the result set.
rank() assigns a unique rank to each row, with ties receiving the same rank and the next rank skipped.
dense_rank() assigns a unique rank to each row, with ties receiving the same rank and the next rank not skipped.
Top trending discussions
DSA based on any general language prefer C++
I applied via Naukri.com and was interviewed in Nov 2024. There was 1 interview round.
I applied via Job Portal and was interviewed in Nov 2024. There were 2 interview rounds.
My approach to building basic logic skills involves practicing problem-solving exercises, breaking down complex problems into smaller parts, and seeking feedback to improve.
Practice problem-solving exercises regularly to strengthen logical thinking abilities.
Break down complex problems into smaller, more manageable parts to better understand the problem and find solutions.
Seek feedback from peers or mentors to identify...
I applied via Naukri.com and was interviewed in Jul 2024. There was 1 interview round.
I applied via Naukri.com and was interviewed in Sep 2024. There was 1 interview round.
I applied via Naukri.com and was interviewed in Jul 2024. There was 1 interview round.
Python code for solving a string usecase using stack, SQL join and groupby queries
I applied via Naukri.com and was interviewed in Jun 2024. There was 1 interview round.
Dirty read is when a transaction reads data that has been modified by another transaction but not yet committed.
Occurs when a transaction reads uncommitted data from another transaction
Can lead to inconsistent or incorrect results
Can be prevented by using proper isolation levels in database transactions
Count of rows in different types of joins in SQL
Inner join: Counts only the rows that have matching values in both tables
Left join: Counts all rows from the left table and the matching rows from the right table
Right join: Counts all rows from the right table and the matching rows from the left table
posted on 20 Jun 2024
Process Associate
420
salaries
| ₹1.8 L/yr - ₹4 L/yr |
Senior Process Associate
131
salaries
| ₹2.4 L/yr - ₹6.2 L/yr |
Business Analyst
60
salaries
| ₹8 L/yr - ₹25.5 L/yr |
Team Lead
60
salaries
| ₹5.2 L/yr - ₹15 L/yr |
Developer 2
58
salaries
| ₹8.7 L/yr - ₹24.6 L/yr |
Yardi Systems
MRI Software
Buildium
Entrata