SailPoint Technologies Data Analyst Interview Questions and Answers

It was more about soft skills based on your work experience

Q1. Team interview - job responsibilites and work exp
Add your answer

Q1. Describe a time when y ou had to learn a new kill to complete a project
Add your answer
Q2. Tell me about your resume
Add your answer

Reverse a given string using for loop

Q1. Tell me about yourself?
Add your answer

Q1. Write an SQL query to fetch duplicates.
Ans. 
SQL query to fetch duplicates
• Use GROUP BY and HAVING clause to identify duplicates

• Select columns to be checked for duplicates

• Example: SELECT column_name, COUNT(*) FROM table_name GROUP BY column_name HAVING COUNT(*) > 1;
Answered by AI
Add your answer
Q2. Write SQL query to fetch nth highest Salary.
Ans. 
SQL query to fetch nth highest Salary
• Use the ORDER BY clause to sort the salaries in descending order

• Use the LIMIT clause to fetch the nth highest salary

• Consider handling cases where there might be ties for the nth highest salary
Answered by AI
Add your answer