SELECT DISTINCT ( CONVERT(date,FechaCreacion)) FROM Tabla where ID = 4 order by CONVERT(date,FechaCreacion) desc OFFSET (0 * 20) ROWS FETCH NEXT 20 ROWS ONLY ;
A1. 2021-03-16 2. 2021-03-15 3. 2021-03-14 4. 2021-03-13 5. 2021-03-11 6. 2021-03-09 7. 2021-03-02 8. 2021-02-28 9. 2021-02-25 10. 2021-02-24 11. 2021-02-23 12. 2021-02-22 13. 2021-02-21 14. 2021-02-19 15. 2021-02-10 16. 2020-11-30 17. 2020-10-05 18. 2020-02-18
var query = (from sp in esquema.Tabla where sp.ID== 4 orderby DbFunctions.TruncateTime(sp.FechaCreacion) descending select new { fechacreacion = DbFunctions.TruncateTime(sp.FechaCreacion) } ).Skip(0* 20).Take(20).ToList().Distinct();
1. 2021-03-16 2. 2021-03-15 3. 2021-03-14 4. 2021-03-13 5. 2021-03-11 6. 2021-03-09 7. 2021-03-02 8. 2021-02-28 9. 2021-02-25 10. 2021-02-24 11. 2021-02-23
).Skip(0* 20).Take(20).ToList().Distinct();
).Distinct().Take(20).ToList();
Distinct()
Distinct
Skip
Take
ToList
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)