1. Difference between EXISTS and IN in SQL?
2. Difference between UNION and UNION ALL?
3. Difference between INNER JOIN, LEFT JOIN, RIGHT JOIN and FULL JOIN?
4. Difference between JOIN and INNER JOIN?
5. Difference between count (column) and count(*)?
6. Difference between <> and != in SQL?
7. Difference between Left join and Left outer join?
8. Difference between VARCHAR and CHAR?
9. Difference between in, any and all operators in sql?
10. Difference between HAVING and WHERE?
11. Difference between stored procedure and functions?
12. Difference between char, nchar, varchar, and nvarchar in SQL Server?
13. Difference between before and after trigger in SQL?
14. Difference between clustered and a non-clustered index?
15. Difference between TRUNCATE and DELETE?
No comments:
Post a Comment