Return Top Five Recodrs From Table

Total Post:12


 2048  View(s)
Rate this:
Hi All,

Could anyone please help me out. How to query in sql server 2008 to get
top 5 records.

  1. Re: Return Top Five Recodrs From Table

    Hi Anoop,

    You can select top 5 records from your table by using sql server top(<number of rows>) function.

    Here is an example, which selects top 5 records from table student_record.

    top(5) * from student_record

      Modified On Mar-29-2018 02:11:51 AM


Please check, If you want to make this post sponsored

You are not a Sponsored Member. Click Here to Subscribe the Membership.