Buy Questpond's video subscriptions on
huge discount
.
Online: 1738
Home
Articles
Interviews
Forums
For Beginners
Popular Questions
ITIL Career Advice
PMP Career Advice
Career Advices
Codes
Videos
ASP.NET
ASP.NET MVC
Android Intel XDK
Sql Server
AngularJS
Bootstrap
Backbone.JS
MongoDB
LESS (CSS)
jQuery
WPF
WWF
SSIS
LightSwitch
Tutorials
News
ASP.NET MVC
|
Be Interview Ready
|
Top Performers
|
DNF MVP
|
Top Posts
|
Winners
|
Subscribe
|
Catalogs
Welcome Guest !
Register
Login
Home
>
Interviews
>
Sql Server
>
Loading ...
Which of the following new analytic functions introduced in SQL Server 2012 returns the last value in an ordered set of values?
Posted by
Bandi
on 11/30/2013 | Category:
Sql Server Interview questions
| Views: 5851 |
Points: 40
Post
|
Interview FAQs
|
Exclusive Questions
|
Interview Home
Select from following answers:
LAST_ROW
LAST_VALUE
LAG_VALUE
None
All Above
LAST_VALUE() is introduced in SQL Server 2012. It returs the last value in an ordered set of values
Show Correct Answer
Asked In:
Many Interviews |
Alert Moderator
Bookmark It
< Previous :
DECLARE @UnitPrice MONEY = 12345.6789 SELECT ...
Next > :
Which of the following error severity levels can b ...
Comments or Responses
Login to post response
More Interview Questions by Bandi
Which of the following error severity levels can be caught in a TRY... ...
Which data type in SQL Server 2008 represents data in a Euclidean coor ...
Which of the following Transact-SQL statement disables the change trac ...
Which of the following system stored procedure is used to delete e-mai ...
Which of the following functions assign sequential numbers to rows of ...
SELECT CHOOSE(2, 1, 'Option 1', GETDATE(), 3.14159, PI() ); w ...
How to write recursive query in SQL Server?
Which of the following functions is a new logical function introduced ...
Latest Interview Questions
What will happen,if we compile below code public interface intf_per ...
In VB.Net Overloads keyword is used for which type? Public Over ...
What is the best example of Function Overloading?
What will happen,if we compile below function? private double sum(i ...
What will happen,if we compile below function:- private double sum( ...
What will happen,if we compile below function? private double sum(i ...
What are the points which fulfill Function Overloading?
Does Function Overloading depend on Return Type?
More ...
Show Correct Answer