GlobalLogic
Flipkart Interview Questions and Answers
Q7. What is CTE ? And Write a Sample Query ?
CTE stands for Common Table Expressions, used to create temporary result sets within a SQL query.
CTE is defined using the WITH keyword in SQL.
It helps in simplifying complex queries by breaking them into smaller, more manageable parts.
CTEs can reference themselves recursively, making them useful for hierarchical data.
Example: WITH cte AS (SELECT * FROM table_name) SELECT * FROM cte;
Q8. Print Numbers between 1 to 20 , even/odd numbers
Print even and odd numbers between 1 to 20.
Iterate from 1 to 20 and check if the number is even or odd.
Use a conditional statement to determine if the number is even or odd.
Print the number along with its type (even or odd).
Interview Process at Flipkart
Top Senior Software Developer Interview Questions from Similar Companies
Reviews
Interviews
Salaries
Users/Month
Made with ❤️ in India. Trademarks belong to their respective owners. All rights reserved © 2024 Info Edge (India) Ltd.
