Why not like this? insert into t (a, b, c, d, e, idate) SELECT a, b, c, 'y', e, '2019-02-12' FROM t WHERE a = 'p001' ORDER BY idate desc limit 1;
On Fri, Nov 15, 2019 at 9:19 AM Simon Slavin <slav...@bigfraud.org> wrote: > > On 14 Nov 2019, at 10:06pm, Jose Isaias Cabrera <jic...@outlook.com> wrote: > > > insert into t (a, b, c, d, e, idate) values > > ( > > (SELECT a FROM t WHERE a = 'p001' ORDER BY idate desc limit 1), > > (SELECT b FROM t WHERE a = 'p001' ORDER BY idate desc limit 1), > > (SELECT c FROM t WHERE a = 'p001' ORDER BY idate desc limit 1), > > 'y', > > (SELECT e FROM t WHERE a = 'p001' ORDER BY idate desc limit 1), > > '2019-02-12' > > ); > > > > Is there a simpler way? Thanks. > > No simpler way. I suggest you duplicate the exiting row first, then UPDATE > the duplicate. > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users