Filter interviews by
Clear (1)
I applied via Indeed and was interviewed before May 2023. There was 1 interview round.
Top trending discussions
posted on 27 Apr 2022
posted on 14 Jul 2024
SQL rank order function explanation
Rank order function in SQL assigns a rank to each row based on a specified column
It can be used to determine the top or bottom N records in a dataset
Example: SELECT column1, column2, RANK() OVER (ORDER BY column3 DESC) AS rank_order FROM table_name
Merging two tables involves combining data from both tables based on a common key.
Identify a common key between the two tables
Use SQL JOIN statements to merge the tables
Choose the appropriate type of join (e.g. inner join, outer join)
Consider the size of the tables and the performance implications of the merge
I applied via Naukri.com and was interviewed before Apr 2021. There were 3 interview rounds.
Answering questions related to sales cycle, current role, target achievement, negotiation, and travel.
Ideal sales cycle involves identifying potential customers, building relationships, understanding their needs, presenting solutions, and closing the deal.
In my current role, I am responsible for managing a team of sales representatives, developing sales strategies, and achieving sales targets.
I have consistently achiev...
I applied via Naukri.com and was interviewed before Sep 2020. There were 3 interview rounds.
Join in SQL is used to combine rows from two or more tables based on a related column between them.
Join is used to retrieve data from multiple tables based on a related column
Types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN
Example: SELECT * FROM table1 INNER JOIN table2 ON table1.column = table2.column
Primary key is a unique identifier for each record in a database table.
Primary key ensures each record in a table is uniquely identified
It must contain unique values and cannot have NULL values
Primary key can be a single column or a combination of columns
Example: 'ID' column in a 'Users' table can be a primary key
I applied via Naukri.com and was interviewed in Mar 2021. There were 3 interview rounds.
based on 1 interview
Interview experience
based on 3 reviews
Rating in categories
Receptionist
322
salaries
| ₹0 L/yr - ₹0 L/yr |
Assistant Engineer
123
salaries
| ₹0 L/yr - ₹0 L/yr |
Junior Officer
120
salaries
| ₹0 L/yr - ₹0 L/yr |
Engineer
111
salaries
| ₹0 L/yr - ₹0 L/yr |
Quality Engineer
87
salaries
| ₹0 L/yr - ₹0 L/yr |
Samsung
LG Electronics
Sony
Panasonic Avionics Corporation