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