SQL Interview Questions

SQL Interview Questions

1. What is the logical order of execution of SELECT statement? (You tube Video Link) (Click here for Text version Answer)

2. What are the differences between Primary Key and Unique Key Key (You tube Video Link) (Click here for Text version Answer)

3. Sorting Interview Questions Part - 1 SQL (You tube Video Link) (Click here for Text version Answer)

4. What are the differences between Truncate, Delete and Drop in SQL (You tube Video Link) (Click here for Text version Answer)

5. How to Remove Duplicate Records and retain one Unique record ? (You tube Video Link) (Click here for Text version Answer)

6. Tricky CASE Statement Interview Questions? (You tube Video Link) (Click here for Text version Answer)

7. Length Vs Data Length Vs Column Length  (You tube Video Link) (Click here for Text version Answer)

8. How to calculate Running total / Cumulative Sum in SQL?  (You tube Video Link) (Click here for Text version Answer)

9. Temporary Tables in SQL Server / Temp Tables (You tube Video Link) (Click here for Text version Answer)

10. Temporary Tables Quick Practical in SQL Server / (You tube Video Link) (Click here for Text version Answer)

11. Table Variables in SQL Server / (You tube Video Link) (Click here for Text version Answer)

12. Importing tables from one server to another server using SQL Server/ (You tube Video Link) (Click here for Text version Answer)

13. Find Employees whose Salary is Lower than their Department Average Salary / (You tube Video Link) (Click here for Text version Answer)

14. Find Employees Whose Salary Higher Than Their Manager Salary / (You tube Video Link) (Click here for Text version Answer)

15. Import data from File to table in SQL Server |Import Flat File / (You tube Video Link) (Click here for Text version Answer)

16. How to find Nth highest Salary?