Link to home
Start Free TrialLog in
Avatar of chrisryhal
chrisryhal

asked on

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
ASKER CERTIFIED SOLUTION
Avatar of cmhunty
cmhunty

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Avatar of Aneesh
Aneesh
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of cmhunty
cmhunty

Snap!
>cmhunty
may be u got some better internet connection
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.
Avatar of chrisryhal

ASKER

I split the points since you both came in almost the same time :)

Thanks again, I knew it had to be something easy