Explain having clause and where clause?


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

Post New Answer

More SQL Server Interview Questions

How to define and use table alias names in ms sql server?

0 Answers  


What are policy management terms?

0 Answers  


How do I find the transaction log size in sql server?

0 Answers  


Explain what is the purpose of sql profiler in sql server?

0 Answers  


What is the difference between cube operator and rollup operator? : SQL Server Architecture

0 Answers  






What do you understand by recursive stored procedures?

0 Answers  


How to call a function from a stored procedure in SQL Server ?

0 Answers   HCL,


After the SQL installation what are the jobs will you configure?

1 Answers   G7 CR Technologies, IBM, Satyam,


How to create logins using windows Authentication mode?

2 Answers  


Following are some of the question related to below mentioned query? select e1.salary from employee3 e1 where 2= ( select count(distinct(e2.salary)) from employee3 e2 where e2.salary>=e1.salary ) 1) What the query returns? 2) How it works? - Detail explanation (what the sub query does, why it is (where 2=)....etc...Please?

5 Answers  


Repair mdf file

2 Answers  


4 Please write a querry to find repeated numbers in the following table. Table Name: Table1 Field1 10 15 20 15 10

7 Answers  


Categories