Home > Interview Questions > SQL Server > What is the use of FIRST() function in SQL SERVER?

What is the use of FIRST() function in SQL SERVER?

by Narain Siddharth   on 01/06/2011   Category: SQL Server   |  Level: Beginner   |  Views: 1536    |  Points: 25     |  Silver 


The first() function used to returns the first value of the selected column.

for example, select the first value of the employee table

SELECT FIRST(emp_name) FROM employee

the result like as shown below

emp_name
Arvind



« what is the use of @@ROWCOUNT function in SQL server?
» What is SQL INJECTION?
Post Question  |  Question Home

Recent Posts

User Responses


No response found, be the first to review this question.

Submit feedback about this code snippet

Please sign in to post feedback

Latest Posts

1 3D model and 2D View New! Forum