Скачать или смотреть 👉 Master SQL for Infosys and TCS Interviews. Wondering how?

#IIDST #SQL #sql

Infosys SQL Interview Questions-

1. Write a query to find the second-highest salary from an employee table.
2. How would you use a JOIN to combine data from two tables: one with employee information and another with department information?
3. Write a query to retrieve employees who joined in the last 30 days.
4. How can you handle NULL values in SQL when performing calculations?
5. Explain the difference between WHERE and HAVING clauses in SQL.
6. Write a query to find the count of employees in each department.
7. How would you optimize a slow-running query?
8. Write a query to update the salary of all employees by 10%.
9. Explain the purpose of indexes and how they improve query performance.

TCS SQL Interview Questions-

1. Write a query to create a new table with columns for employee ID, name, and salary.
2. How would you retrieve the top 5 highest-paid employees from an employee table?
3. Write a query to delete duplicate rows from a table based on a specific column.
4. Explain the difference between INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL OUTER JOIN.
5. Write a query to calculate the average salary for each department.
6. How do you use the CASE statement in SQL, and provide an example?
7. Write a query to find employees who have not been assigned to any department.
8. Explain the concept of a primary key and a foreign key in SQL.
9. Write a query to add a new column to an existing table.

#tcs #iidst #sql #viral #viralvideos #trending #trending #datascience #interviewtips #explorepage #explore #reels #reels #trendingreels #instagram #sqlinterviewquestions #viralreels #IIDST #sql #tag #interview #infosys


Visit our website for more information:
http://iidst.org/data-science-course

Instagram:   / iidstorg  
Facebook:   / iidstorg