so, just to clarify, you want something like this? <https://lh3.googleusercontent.com/-obun7Yc03mg/WSijLe7PjYI/AAAAAAAAADs/bOSE5WKfURYSNx8t9CDXhVW-1EL6OnhNgCLcB/s1600/Screenshot%2Bfrom%2B2017-05-26%2B23-50-24.png>
Il giorno venerdì 26 maggio 2017 13:28:57 UTC+2, Pugazharasan Thirumalai ha scritto: > > 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.
