Equivalent for LEAD and LAG functions SQL server

Hi Team,

               I am trying to migrate from SQL server database to NuoDB database for which i am working on finding the equivalent NuoDB queries. I have a scenario of a table with one column containing list of timestamp values whoch i want to split into rows containing 100 records for a range(start_time and end_time).I can do this in SQL server using LEAD and LAG . But i am clueless here as nuoDB does not support LEAD,LAG and NTILE. Kindly help me in framing such queries for the above said scenario in NuoDB syntax. Your timely help is much appreciated . 


1 comment

Please sign in to leave a comment.