Sankey Solutions Solution Analyst Interview Questions, Process, and Tips

Give 2 codes and we have to write a logic

Q1. Write a recursion program.
Ans. 
A recursion program is a function that calls itself until a base case is reached.
• Identify the base case and write the code to handle it

• Write the recursive case that calls the function with a modified input

• Ensure the recursive case moves towards the base case

• Example: Factorial function: function factorial(n) { if (n === 0) { return 1; } else { return n * factorial(n-1); } }

• Example: Fibonacci sequence: function fibonacci
Answered by AI
View 1 more answer
Q2. What are the Aggregate functions in sql
Ans. 
Aggregate functions in SQL are used to perform calculations on a set of values and return a single value.
• Common aggregate functions include SUM, AVG, COUNT, MAX, and MIN.

• SUM calculates the total of a set of values.

• AVG calculates the average of a set of values.

• COUNT counts the number of values in a set.

• MAX returns the highest value in a set.

• MIN returns the lowest value in a set.
Answered by AI
View 1 more answer

Q1. MySql basic, Oops concept
Add your answer
Q2. Find 2nd highest salary
Ans. 
To find the 2nd highest salary, use a subquery to select the max salary that is not the highest.
• Use a subquery to find the maximum salary that is not the highest

• Select the maximum salary from the table where the salary is less than the highest salary

• Order the results in descending order and limit the result to the second row
Answered by AI
Add your answer

Q1. About your self
Add your answer

Q1. Write your name 100 times without using any loop.
Ans. 
Answering the question of writing name 100 times without using any loop.
• Write your name 100 times manually

• Use copy-paste feature to write your name multiple times

• Use a script or program to generate your name 100 times
Answered by AI
View 3 more answers
Q2. Remove duplicate from array
Ans. 
Remove duplicates from an array
• Use a loop to iterate through the array

• Use a hash table to keep track of unique values

• If a value is already in the hash table, remove it from the array
Answered by AI
Add your answer

2 coding questions

Q1. Why should we hire you?
Add your answer