how can we select the first record in a given set of rows?

Blessy Baby
Digitalmesh Softech pvt Ltd
https://blessybaby.wordpress.com/

Declare @t table(Emp_Id int identity, Emp_name varchar(20), Gender varchar(1)) 

Insert into @t 

				Select 'sanjay','M' union all Select 'julie','F' union all

				Select 'santwana','M' union all Select 'ss ss','M' union all

				Select 'sanjay345','M' 



Select x.* From(

Select Rn = ROW_NUMBER() Over(Order by(select 1)),*

From @t)x

where x.Rn =1

Select Top 1 * From @t

Rn	Emp_Id	Emp_name	Gender

1	1	sanjay	M

Best Regards,
Niladri Biswas