10
Reply

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

HARDIK BHAVSAR

HARDIK BHAVSAR

Aug 16 2013 5:52 AM
1.2k
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)