- Explain the order of execution of SQL.
- What is the difference between where and having?
- What is the use of a group by?
- Explain all types of joins in SQL?
- What are triggers in SQL?
- What is the stored procedure in SQL
- Explain all types of window functions? (Mainly rank, row_num, dense_rank, lead & lag)
- What is difference between Delete and Truncate?
- What is difference between DML, DDL and DCL?
- What are aggregate function and when do we use them? explain with few example.
- Which is faster between CTE and Subquery?
- What are constraints and types of Constraints?
- Types of Keys?
- Different types of Operators ?
- Difference between Group By and Where?
- What are Views?
- What are different types of constraints?
- What is difference between varchar and nvarchar?
- Similar for char and nchar?
- What are index and their types?
- What is an index? Explain its different types.
- List the different types of relationships in SQL.
- Differentiate between UNION and UNION ALL.
- How many types of clauses in SQL ?
- What is the difference between UNION and UNION ALL in SQL?
- What are the various types of relationships in SQL?
- Difference between Primary Key and Secondary Key?
- What is the difference between where and having?
- Find the second highest salary of an employee?
- Write retention query in SQL?
- Write year-on-year growth in SQL?
- Write a query for cummulative sum in SQL?
- Difference between Function and Store procedure ?
- Do we use variable in views?
- What are the limitations of views?
Monday, July 31, 2023
SQl Interview Quetions
Subscribe to:
Post Comments (Atom)
-
change company:- If you're working on one company within your code but need to insert data into another company, you'd indeed uti...
-
In this blog, I'm explaining how to Use the trace parser tool in D365FO. Any application at some point faces slow performance issues. It...
No comments:
Post a Comment