Services
Technology Web App Development Mobile App Development Windows App Development Database Development UI/UX Development Cloud Development SEO Digital Marketing Guest Posting Content Writing Artificial Intelligence Data Science ERP Development CRM Development CMS Development LMS Development Business Listing Blockchain Technology Startup Promotion AI Tools Integration
Products
Data Converter Cleaner TUC - Unit Converter Import Export Survey Manager Tweet Controller
Developer
Article Blog Forum Interview Beginner News Startup Quiz
Users
Career
Apply Job Internship
Pricing
Login Sign Up Get a Quote

forum

home / developersection / forums / return top five recodrs from table
Ask Question

Return Top Five Recodrs From Table

Anoop Singh 2783 08 Oct 2010
Hi All,
Could anyone please help me out. How to query in sql server 2008 to get
top 5 records.
Return Top Five Recodrs From Table Return Top Five Recodrs From Table thanks
mssql server mssql server
Updated 08 Oct 2010
Anoop Singh
Anoop Singh

Other

Message

1 Answers

Anonymous User
Anonymous User 08 Oct 2010
Report Abuse
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.
select
top(5) * from student_record
advertising