Monday 1 August 2011

Explain FIRST function in SQL Server.

The FIRST function displays the first value of the selected column.

Ex :
Select first(EmployeeID) as FirstEmployeeID from Employees

This Query will display the first value of “EmployeeID” column, the output will be displayed with the column name “FirstEmployeeID”.

Labels:


Bookmark this Blog in your Favorites

0 Comments:

Post a Comment

Subscribe to Post Comments [Atom]

<< Home