You have two tables in your database namely, currentStock and previousStock. These both tables have productName column. you need to display the name of all products from these both the tables,but leave off the twin course names. whcih operator should you use in query for getting desire output?

 Posted by Rajkatie on 6/27/2015 | Category: Sql Server Interview questions | Views: 578 | Points: 40
Select from following answers:
  1. Union all
  2. Union
  3. Intersect
  4. All Above

Show Correct Answer


| Alert Moderator 

Comments or Responses

Login to post response