Hello, sqlite> create table source_table(value); sqlite> create table max_value(max_value); sqlite> insert into max_value select max(value) from source_table; sqlite> select * from table_max_value; max_value
sqlite> How can the maximum value of column source_table.value be inserted into max_value only if there are records in source_table? (If source_table is empty, nothing should be inserted into max_value, not even a NULL) _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
