Office Document APIs for .NET
ITIL Career Advice
PMP Career Advice
Android Intel XDK
Welcome Guest !
What will be the output?
;with cte as(select rn=1 union all select rn=rn+1 from cte where rn<10)
select * from cte
on 8/24/2016 | Category:
Sql Server Interview questions
| Views: 1112 |
Select from following answers:
Values from 1 to 10
Values from 1 to 9
Values from -1 to -10
Values from -1 to -9
This is a recursive common table expression. It will start the value of rn=1 and it in the recursive part it will keep on increment the value of rn each time to 1 till it satisfies the stopping condition. The output will be 1 to 10
Show Correct Answer
Many Interviews |
< Previous :
Explain the purpose of constructor() in Aurelia
Next > :
What is the significance of index.html in Aurelia ...
Comments or Responses
Login to post response
More Interview Questions by Rajnilari2015
What is the significance of index.html in Aurelia?
Explain "Hello World " in Aurelia
What does <body aurelia-app="src/main"> signifies?
In Aurelia, what does system.js contains?
Explain System.import('aurelia-bootstrapper'); in Aurelia
Identity the features of Aurelia
What is Aurelia?
What will be the output of i and how many times it will be printed?
Latest Interview Questions
What object can help you maintain data across users?
What is Bootstrap and why it is used?
Which class is used to display black navigation bar
Which is not correct statement regarding Angular.js?
For using SqlConnection which namespace is required or SqlConnection i ...
How to declare the default value of C# variables?
How to manage session state in Azure? (OR) what is Redis cache i ...