Answer Posted / satyanarayana
In order to provide a condition to the select statement
either by group by column or aggregate function
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What are the advantages of mirroring?
What are the transaction properties?
Thanks to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?
can an automatic recovery be initiated by a user? : Sql server administration
Explain in brief about Microsoft SQL server?
how would you write a sql query to compute a frequency table of a certain attribute involving two joins? What changes would you need to make if you want to order by or group by some attribute? What would you do to account for nulls?
List out different types of normalizations in sql server and explain each of them?
What is the use of RDBMS?
What are the benefits of normalization?
How do I change my passwords (database, LDAP, and so on) without causing an outage?
What are the different types of locks in the database?
What is 3nf normalization form?
What is @@error in sql?
Types of Authentications in Sql Server? How user gets authenticated through windows authentication?
How to transfer data from a cursor to variables with a "fetch" statement?