Thread by @SachinK02316651

📕#SQL is super important. These are the questions that you will have face in interviews which helps you to ace your sql interviews

Credit - Shri Ajay Kadiyala Sir 🔥

🧵👇

Q1. Explain the various types of Joins?
2. Explain Equi join?
3. Explain the Right Outer Join?
4. How do you alter the name of a column?
5. how can you build a stored procedure?
6. Distinguish between MongoDB and MySQL ?

Q7. Compare the 'Having' and 'Where' clauses in detail?
8. What are the differences between COALESCE() and ISNULL()?
9. What is the difference between “Stored Procedure” and “Function”?
10. What is the difference between the “DELETE” and “TRUNCATE” commands?

11. What is difference between “Clustered Index” and “Non Clustered Index”?
12. What is the difference between “Primary Key” and “Unique Key”?
13. What is the difference between a “Local Temporary Table” and “Global Temporary Table”?

14. What is the difference between primary key and unique constraints?
15. What are the differences between DDL, DML and DCL in SQL?
16. What is a view in SQL? How to create view?
17. What is a Trigger?

8. What is the difference between Trigger and Stored Procedure?
19. What are indexes?
20. What are Primary Keys and Foreign Keys?
21. What are wildcards used in database for Pattern Matching?
22. What is Union, minus and Interact commands?

23. What is RDBMS?
24. What is OLTP?
25. What is Aggregate Functions?
26. What is the difference between UNION and UNION ALL?
27. What is a foreign key, and what is it used for?

✅🧵Scenario Based Questions--👇

❗ SQL Query to find second highest salary of Employee?
❗ SQL Query to find Max Salary from each department?
❗ Write SQL Query to display current date?
❗ Write an SQL Query to check whether date passed to Query is date of given format or not?

❗ Write a SQL Query to print the name of distinct employee whose DOB is between 01/01/1960 to 31/12/1975?
❗ Write an SQL Query to find employee whose Salary is equal or greater than 10000?
❗ Write an SQL Query to find name of employee whose name Start with ‘M’?
#DataScience

❗ Find the 3rd MAX salary in the emp table?
❗ Suppose there is annual salary information provided by emp table.
❗How to fetch monthly salary of each and every employee?
❗Display the list of employees who have joined the company before 30th June 90 or after 31st dec 90?
#SQL

📌Follow @SachinK02316651 For More Update
✅SQL
✅EXCEL
✅PYTHON
✅Tweet on Current Affairs 🌎

#python #excel #currentaffairs