Hi, I’d vote for
[2] select last(s1), last(s2) from root.sg.d align by sensor It looks simple, it's easy to use, it's human logic Thanks --- Dawei Liu > 2020年2月21日 下午5:26，Wei Shao <[email protected]> 写道： > > Hi, > > > I'd vote for > [4]. select last s1, s2 from root.sg.d > > > Thanks, > Wei > > > > At 2020-02-21 17:08:14, "Wei Shao" <[email protected]> wrote: >> Hi, >> >> >> We are to determine the exact syntax of Last Query for IoTDB. Last query is >> to select the latest time-value pair result for a given timeseries. >> You can choose from the following syntax options. >> 1. select last(s1), last(s2) from root.sg.d >> 2. select last(s1), last(s2) from root.sg.d align by sensor >> 3. select last(s1, s2) from root.sg.d >> 4. select last s1, s2 from root.sg.d >> 5. last s1, s2 from root.sg.d >> 6. select s1, s2 from root.sg.d last >> 7. select s1, s2 from root.sg.d onlylast >> >> >> Please vote for the option you are comfortable with. >> >> >> Thanks, >> Wei
