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

[srini]

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

HTH
srini
"Kenneth Keeley" wrote:

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


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[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

"srini" <sr***@discussions.microsoft.com> wrote in message
news:23**********************************@microsof t.com...

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

HTH
srini
"Kenneth Keeley" wrote:

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