Tech
Forums
Jobs
Books
Events
Interviews
Live
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
10
Reply
how to display top 5 records in the table using function.
HARDIK BHAVSAR
Aug 16 2013 5:52 AM
1.2k
Reply
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
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
10
)
Next Recommended Forum
Need help of inner join For different table
SQL Query