What will be the output of

with cte as
( select 1 as rn,'DNF ' as data
union all
select rn+1, 'DNF ' as data from cte where rn<5)

select data from cte option (maxrecursion 0)

 Posted by Rajnilari2015 on 1/24/2016 | Category: Sql Server Interview questions | Views: 1577 | Points: 40
Select from following answers:
  1. DNF DNF DNF DNF DNF
  2. DNF DNF DNF DNF DNF DNF
  3. DNFDNFDNFDNFDNF
  4. DNF DNF DNF DNF DNF DNF
  5. All Above

Show Correct Answer


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response