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
What is a trace frag? Where do we use it?
What are the different ways of moving data/databases between servers and databases in SQL Server?
Describe in brief system database.
what are the main differences between ms access and sqlserver
What stored procedure would you use to view lock information?
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>
Write a query to find 5th highest amount paid from the customer table.
What is a benefit of using an after insert trigger over using a before insert trigger?
Explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?
Why are sql functions used?
What are the parts of a function?