Jet2 Travel Technologies Analyst Interview Questions and Answers for Experienced

Q1. Difference Between Union and Union All
Ans. 
Union combines and removes duplicates, Union All combines without removing duplicates
• Union combines result sets and removes duplicates

• Union All combines result sets without removing duplicates

• Union is slower than Union All as it involves removing duplicates

• Example: SELECT column1 FROM table1 UNION SELECT column1 FROM table2;

• Example: SELECT column1 FROM table1 UNION ALL SELECT column1 FROM table2;
Answered by AI
Add your answer
Q2. SQL Execution order
Add your answer
Q3. Coalesce function in SQL
Ans. 
Coalesce function in SQL is used to return the first non-null value in a list of expressions.
• Coalesce function takes multiple parameters and returns the first non-null value.

• It is commonly used to handle null values in SQL queries.

• Example: SELECT COALESCE(column_name, 'N/A') FROM table_name;
Answered by AI
Add your answer

Q1. Self Introduction
Add your answer
Q2. Salary Expectation
Add your answer

Q1. 14 questions in excel formulas
Add your answer

Q1. SQL and excel questions intermediate
Add your answer

Q1. About your past experience
Add your answer
Q2. Reason for leaving the last job
Add your answer

Q1. Process related and journal entries for the questions previously prepared kept by the interviewer.
Add your answer

Aptitude, Logical reasoning and Gaming. Sometimes, they will ask to write an essay for the given picture

Q1. Some puzzles, then resume details
Add your answer

Basics of SQL was asked, having good foundation will really help in clearing this round