sql - How to store multiple values from select subquery -
hi having problem in following query: update tbl set somecol = somecol key = (select key tbl group key having count(*) > 1) , time = (select max(time) tbl) above query works fine when there 1 key. if there more 1 keys query doesn't work. how store multiple values select subquery? time column can multiple. new sql. please guide. in advance. use in predicate: update tbl set somecol = somecol key in (select key tbl group key having count(*) > 1) , time = (select max(time) tbl)