⟩ What are aggregate functions?
Aggregate functions: these functions perform calculation on a column and return a single value. Example: AVG(), SUM(), MIN(), MAX()
Question and Answer:
Home MS SQL Server Functions
- Share
Popular Answers:
* There is no answer to the above question yet.
More Questions for you:
There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly inserted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better?
What are constraints? Explain different types of constraints?
What is a self join? Explain it with an example.?
What is an extended stored procedure? Can you instantiate a COM object by using T-SQL?
What are triggers? How many triggers you can have on a table? How to invoke a trigger on demand?
What type of Index will get created after executing the above statement?
What is a transaction and what are ACID properties?
What is normalization? Explain different levels of normalization?
What is the system function to get the current user's user id?
Can we have a nested transaction?
