What is difference between aggregate and analytic function?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL Server Interview Questions

Give an example of why you would want to denormalize a database

0 Answers  


What is the difference between nvl and nvl2?

0 Answers  


What is a trace frag?

0 Answers  


What is bcnf normalization form?

0 Answers  


Do you know what are the restrictions that views have to follow?

0 Answers  






What is the difference between HAVING clause and the WHERE clause?

7 Answers  


How do you find value of first column before inserting value into the second column in the same table for checking that second column must have different value than first column.

2 Answers   L&T,


What are the tables in sql?

0 Answers  


Do you know what is a trace frag? Where do we use it?

0 Answers  


i want table name basis on column name.

5 Answers  


How can I check that whether automatic statistic update is enabled or not?

0 Answers  


There is table like Events...in that name ,startdate ,enddate,location are the column names write a stored Procedure for this table to get events by Months "GetEventsByMonths"

2 Answers  


Categories