Retirn only a limited number of results.

[Kenneth Keeley]

Hi
How can I limit the number of results returned from and SQL database to a
datagrid. Ie I only want to return the latest ten news items for a news and
events page.

Thanks
Kenneth

 

[naija naija]

Hi Kenneth,
I think SQL should be able to tackle that in your Query!
Patrick

 

[Guest]

Hi,
You can do it this way
select top 10 newsitems from newsTable order by date_time

HTH
srini

 

[Anton Sokolovsky]

Latest 10 should have DESC direction of ordering

select top 10 newsitems from newsTable order by date_time desc

assuming that "date_time" is of datetime type