show only 5 records in Datagrid

[desperado]

[Resolved] show only 5 records in Datagrid

Hey people,

Wondering someone could be a star and help me out please. Is there a way where I could show only the top 5 records in the datagrid?

I've been browsing the web but can't find anything.

Thanks

 

[jshultz]

Change your select statement to only pull the top 5 records.

 

[desperado]

Any chance you could help me on the select statement please?

 

[jshultz]

select top 5 * from your_table

 

[desperado]

Sorted, thanks

 

[cjard]

point of note: in future, do define what you mean by "top" ..