• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 202
  • Last Modified:

Only show 5 records

My below query works good, but I only want to show the FIRST 5 records otherwise it will display hundreds that I don't want because I am just trying to HIGHLIGHT the latest records.  I know there has got to be an easy way to do this, so I just thought I would ask.

SELECT * FROM cs_ClassifiedsItem WHERE ModuleID = '495' ORDER BY CreatedDate Desc
0
chrisryhal
Asked:
chrisryhal
2 Solutions
 
cmhuntyCommented:
SELECT TOP 5 * FROM cs_ClassifiedsItem WHERE ModuleID = '495' ORDER BY CreatedDate Desc
0
 
Aneesh RetnakaranDatabase AdministratorCommented:
SELECT top 5 * FROM cs_ClassifiedsItem WHERE ModuleID = '495' ORDER BY CreatedDate Desc

0
 
cmhuntyCommented:
Snap!
0
Granular recovery for Microsoft Exchange

With Veeam Explorer for Microsoft Exchange you can choose the Exchange Servers and restore points you’re interested in, and Veeam Explorer will present the contents of those mailbox stores for browsing, searching and exporting.

 
Aneesh RetnakaranDatabase AdministratorCommented:
>cmhunty
may be u got some better internet connection
0
 
Shanmuga SundaramCommented:
Hi chrisryhal,

Hope that you got your results. This is the only way (what the above members have said) that you can achieve your results .
by
d.Shanmuga sundaram.
0
 
chrisryhalAuthor Commented:
I split the points since you both came in almost the same time :)

Thanks again, I knew it had to be something easy
0

Featured Post

Get quick recovery of individual SharePoint items

Free tool – Veeam Explorer for Microsoft SharePoint, enables fast, easy restores of SharePoint sites, documents, libraries and lists — all with no agents to manage and no additional licenses to buy.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now