Wednesday, July 20, 2011

MySQL Keyword for Retrieving the Top 1000 records

We need to use the limit keyword for this. This is equal to Top keyword in MSSQL server.

Select  * from [DatabaseName].[tablename] Limit 1,1000

No comments:

Post a Comment

Retrieving Calendar of a Bookable Resource in Dynamics

There are occasions where we need to retrieve working days and working times of a resource in Dynamics grammatically. This is quite possible...