forum

Home / DeveloperSection / Forums / Return Top Five Recodrs From Table

Ask Question

Return Top Five Recodrs From Table

Anoop Singh 2422 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 on 08-Oct-2010
Anoop Singh

Anoop Singh

Follow

Can you answer this question?

Answer

1 Answers

Anonymous User

Anonymous User

08-Oct-2010
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

Liked By