Yardi Systems Trainee Interview Questions and Answers

Normal apti test. With day to day life questions very easy

Q1. What are joins in sql. They gave 3 table and asked further questions on that basis
Ans. 
Joins in SQL combine rows from two or more tables based on related columns.
• INNER JOIN: Returns records with matching values in both tables. Example: SELECT * FROM A INNER JOIN B ON A.id = B.id;

• LEFT JOIN: Returns all records from the left table and matched records from the right table. Example: SELECT * FROM A LEFT JOIN B ON A.id = B.id;

• RIGHT JOIN: Returns all records from the right table and matched records from the le...read more
Answered by AI
Add your answer
Q2. Tell me about your self. What do u want. Areas of interest etc
Add your answer