Ascendion Data Analyst Interview Questions and Answers

Q1. Questions on my previous work experience
Add your answer
Q2. SQL Questions based on random scenario
Add your answer

DURATION 1.3 HRS WITH REASONING AND 2 CODING QUESTION

Q1. SQL QUESTION FIND N TH HIGHEST SALARY
Ans. 
Use SQL query with ORDER BY and LIMIT to find the Nth highest salary.
• Use ORDER BY clause to sort salaries in descending order

• Use LIMIT to specify the Nth highest salary

• Example: SELECT salary FROM employees ORDER BY salary DESC LIMIT N,1
Answered by AI
Add your answer
Q2. SQL QUESTION PIVOT TABLE QUESTION
Add your answer

SQL and python questions are very easy.

Q1. Introduce yourself
Add your answer

Hacker Rank test Write a query to fetch the EmpFname from the EmployeeInfo table in upper case and use the ALIAS name as EmpName

Q1. SQL or Structured Query Language is a standard language for dealing with relational databases. With the humongous amount of data present, it is very important for us to understand how to use queries to ret...read more
Add your answer

Provided sales case study, asked to analyse the same ans provide insights