What will be the output of

declare @Table1 table(id int)
insert into @Table1
select 1 union all select 2 union all select 3 union all select 4 union all
select 5 union all select 6 union all select 7 union all select 8

declare @Table2 table(id int)
insert into @Table2
select 1 union all select 2 union all select 5 union all select 8

select id from @Table1 except select id from @Table2

 Posted by Rajnilari2015 on 1/24/2016 | Category: Sql Server Interview questions | Views: 341 | Points: 40
Select from following answers:
  1. 3 4 6 7
  2. 1 2 5 8
  3. 1 2 3 4 5 6 7 8
  4. Error
  5. All Above

Show Correct Answer


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response