Createtablesample
(
ID int,
F_Name nvarchar(20),
L_Name nvarchar(20)
)
insertintosample(ID,F_Name,L_Name)values(1,'Ajay','Pravin')
insertintosample(ID,F_Name,L_Name)values(2,'udhaya','Kumar')
insertintosample(ID,F_Name,L_Name)values(1,'Ravi','Kumar')
Select ID,F_Name as First_Name, L_Name
as Last_Name fromsample