How to apply filtering criteria at group level with the having clause 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 a trace frag? Where do we use it?

0 Answers  


What are the different ways of moving data/databases between servers and databases in SQL Server?

1 Answers  


Describe in brief system database.

0 Answers  


what are the main differences between ms access and sqlserver

1 Answers   C DAC, CDAC,


What stored procedure would you use to view lock information?

0 Answers  






what is Constraint? How many types of constraints in SQL ?

38 Answers   HCL, IBM, NIIT, Wipro,


What is the difference between the following two sql statements select count(*) from <tablename> select count(col_name) from <tablename>

5 Answers   247Customer,


Write a query to find 5th highest amount paid from the customer table.

0 Answers  


What is a benefit of using an after insert trigger over using a before insert trigger?

0 Answers  


Explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?

0 Answers  


Why are sql functions used?

0 Answers  


What are the parts of a function?

0 Answers  


Categories