Can we use where clause in union?


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

Post New Answer

More SQL Server Interview Questions

Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?

0 Answers  


What is difference between unique and primary key?

0 Answers  


is it possible to use a variable in a query with the IN clause (a,b,c..z), without getting quotes or conversion errors?

2 Answers  


Can coalesce return null?

0 Answers  


how many type of subquery?

2 Answers  






How to install sql server 2005 express edition?

0 Answers  


can we have a nested transaction? : Sql server database administration

0 Answers  


Does a server store data?

0 Answers  


Write a stored procedure for emplpoyee and department table to get DeptName which having no employee. Table Structure- Emp-Emp_Id,Emp_Name,Dept_id Dept-Dept_Id,Dept_Name

7 Answers   TCS,


What is inline variable assignment?

0 Answers  


Explain the etl (extraction, transformation, and loading)?

0 Answers  


What is autocommit mode in sql server?

0 Answers  


Categories