i
LeadSquared
Filter interviews by
I applied via Referral and was interviewed before Jul 2023. There were 2 interview rounds.
Union combines the results of two or more SELECT statements, while Union All includes all rows, including duplicates.
Union removes duplicate rows, Union All includes all rows
Union is slower as it has to remove duplicates, Union All is faster
Union requires the same number of columns in each SELECT statement, Union All does not
Different kinds of joins in SQL are inner join, left join, right join, and full outer join.
Inner join: Returns rows when there is a match in both tables.
Left join: Returns all rows from the left table and the matched rows from the right table.
Right join: Returns all rows from the right table and the matched rows from the left table.
Full outer join: Returns rows when there is a match in either table.
Case statement in SQL is used to perform conditional logic and return different values based on specified conditions.
Case statement can be used to replace multiple if-else statements in SQL queries.
It can be used in SELECT, WHERE, and ORDER BY clauses.
Syntax: CASE WHEN condition1 THEN result1 WHEN condition2 THEN result2 ELSE default_result END
Example: SELECT name, CASE WHEN age < 18 THEN 'Minor' ELSE 'Adult' END AS ag
Windows functions in SQL are used to perform calculations across a set of rows related to the current row.
Windows functions are used to calculate cumulative sums, averages, rankings, and more.
Examples include ROW_NUMBER(), RANK(), DENSE_RANK(), SUM() OVER(), AVG() OVER().
I applied via Approached by Company and was interviewed before Jul 2023. There were 3 interview rounds.
I have worked on various software projects, including developing web applications and implementing new features.
Developed a web application for tracking inventory and sales
Implemented new features for a customer relationship management system
Collaborated with team members to troubleshoot and resolve technical issues
My day to day work as a Software Engineer involves writing code, debugging, attending meetings, collaborating with team members, and researching new technologies.
Writing and testing code for software applications
Debugging and troubleshooting issues in existing code
Attending meetings with team members and stakeholders to discuss project progress
Collaborating with other engineers and designers to develop new features
Rese...
1 programming question on Strings and oral questions on Spring Boot and Java
To ensure alignment towards requirements, I will prioritize clear communication, thorough analysis, and regular feedback.
Regularly communicate with stakeholders to clarify requirements and expectations
Conduct thorough analysis of requirements to identify potential issues or gaps
Seek feedback from team members and stakeholders throughout the development process
Use agile methodologies to adapt to changing requirements an
I applied via Approached by Company and was interviewed in Aug 2023. There were 3 interview rounds.
LeadSquared interview questions for popular designations
Get interview-ready with Top LeadSquared Interview Questions
I was interviewed in Jan 2024.
Javascript is a versatile programming language used for web development, with features like dynamic typing, prototypal inheritance, and event-driven programming.
Dynamic typing allows variables to hold values of any type without explicit declaration
Prototypal inheritance enables objects to inherit properties and methods from other objects
Event-driven programming allows for asynchronous execution of code based on user ac
I am passionate about designing innovative solutions and believe in the company's mission and values.
I am excited about the opportunity to work on challenging projects and contribute to the team's success.
I admire the company's commitment to sustainability and cutting-edge technology.
I value the company's focus on employee development and growth opportunities.
I applied via Recruitment Consulltant and was interviewed in Feb 2023. There were 4 interview rounds.
I applied via Job Portal
Top trending discussions
Some of the top questions asked at the LeadSquared interview -
The duration of LeadSquared interview process can vary, but typically it takes about less than 2 weeks to complete.
based on 49 interviews
Interview experience
based on 306 reviews
Rating in categories
Business Analyst
143
salaries
| ₹3.8 L/yr - ₹12 L/yr |
Software Engineer
136
salaries
| ₹6 L/yr - ₹18.7 L/yr |
Senior Software Engineer
104
salaries
| ₹11 L/yr - ₹34.9 L/yr |
Senior Business Analyst
87
salaries
| ₹7.3 L/yr - ₹21 L/yr |
Sales Development Representative
52
salaries
| ₹3.5 L/yr - ₹11.9 L/yr |
Freshworks
Zoho
MindTickle
Chargebee