Can group functions be mixed with non-group selection fields in ms sql server?


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

Post New Answer

More SQL Server Interview Questions

What is the importance of a recovery model?

0 Answers  


What is the maximum rows in sql server table?

0 Answers  


Explain log shipping and mention its advantages.

0 Answers  


find the 3rd max salary

10 Answers  


Differentiate between SQL and ORACLE joins and write their syntax.

0 Answers   Global Logic,






What are the recovery models in sql server 2000?

0 Answers  


Where are sql server user names and passwords stored in sql server?

0 Answers  


What is the difference between two queries: 1. SELECT * FROM table WHERE 1=1; 2. SELECT * FROM table

17 Answers   HP,


What are the different SQL Server Versions you have worked on?

0 Answers  


How do you optimize Sql queries ?

0 Answers   Cognizant,


1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?

0 Answers  


Give a example to search fr a string in all stored procedure in sql server.

0 Answers  


Categories