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
SELECT * FROM cs_ClassifiedsItem WHERE ModuleID = '495' ORDER BY CreatedDate Desc
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Snap!
>cmhunty
may be u got some better internet connection
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.
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.
ASKER
I split the points since you both came in almost the same time :)
Thanks again, I knew it had to be something easy
Thanks again, I knew it had to be something easy