If i execute the query, "select from custom_offer" then am getting the out like this,
PROPERTIES rid class version offer_text offer_code created_date #265:2869 <http://192.168.1.120:2480/studio/index.html#/database/mio/browse/edit/265:2869> custom_offer 5 Promotional Offer BFXVI3EY 2017-01-25 00:00:00 #265:2871 <http://192.168.1.120:2480/studio/index.html#/database/mio/browse/edit/265:2871> custom_offer 5 test L81KSPBZ 2017-03-22 00:00:00 #265:2870 <http://192.168.1.120:2480/studio/index.html#/database/mio/browse/edit/265:2870> custom_offer 5 test 2017-04-12 00:00:00 #265:2868 <http://192.168.1.120:2480/studio/index.html#/database/mio/browse/edit/265:2868> custom_offer 5 Test JHZZTNO4 2017-05-25 00:00:00 >From the above result, Consider as 'created_date' as my offer start date, and we want the query for offer end date ie next record created_date is my offer end date of my first record. For example, #265:2869 <http://192.168.1.120:2480/studio/index.html#/database/mio/browse/edit/265:2869> record offer Start date is 2017-01-25 00:00:00 and end date should be 2017-03-22 00:00:00. So i want the query for getting next record value to first record data by select query. Thanks and Regards, T.Pugazharasan. -- --- You received this message because you are subscribed to the Google Groups "OrientDB" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
