The Yardi SQL Developer interview process includes a pre-HR screening followed by two technical rounds focused on SQL queries, database concepts, and problem-solving, assessing both technical expertise and communication skills.
Interview questions [1]
Question 1
Write an SQL query to find the second highest salary from an Employee table without using TOP or LIMIT.
They took whole day for interview and it felt like the interviewer did not even wanted to take interviews. I guess they might have already got there candidates and were just continuing as an formality.
First was an Online Exam which fairly easy, then followed by an in person interview
questions are like
1. tell me about yourself,
2. basic Sql Questions
3. basic Queries
4. Advanced Queries
Interview questions [1]
Question 1
how to connect two rows having first name and another last name in a table