adspace


Why we need a group by clause?

Answer Posted / sd

While using aggregate functions.

Is This Answer Correct ?    7 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can we do dml on views?

1042


What is self contained sub query?

1148


How raid can influence database performance?

1127


Explain system functions or built-in functions? What are different types of system functions?

1072


What is the primary use of the model database?

1156


What is normalization and what are the advantages of it?

1068


Does view occupy space?

1033


If any stored procedure is encrypted, then can we see its definition in activity monitor?

1083


How do I create a trace in sql server?

1128


List the ways in which dynamic sql can be executed?

1099


what is the difference between openrowset and openquery?

1209


Can we shrink data file in sql server?

1135


What are the properties of the transaction?

1085


Why should you use or avoid select * statements?

1120


How to convert character strings into numeric values?

1197