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
This blog describes mostly about the work (CRM 365, CRM 2016, CRM 2015, CRM2011, CRM 4.0, CRM 3.0, C#,Javascript and SQL Server) i do.
extract(YEAR FROM DATE '2011-07-20') | would return 2011 |
extract(MONTH FROM DATE '2011-07-20') | would return 7 |
extract(DAY FROM DATE '2011-07-20') | would return 20 |
There are occasions where we need to retrieve working days and working times of a resource in Dynamics grammatically. This is quite possible...