Hardik Bhavsar

Hardik Bhavsar

  • NA
  • 164
  • 56.2k

how to display top 5 records in the table using function.

Aug 16 2013 5:52 AM
how to display top 5 records in the table using function.?

i used this query but this query is not wrok on funtcion.
select top 5 * from tablename

using this function only 1 record are display.

alter function fn_TopStudentRecord  
(@name varchar(20))  
returns varchar(20)  
begin   
return (select name from Student1 where name=@name)  
end  


Answers (10)