摘要：
SELECT ti.*FROM ( SELECT pt.*, ROW_NUMBER() OVER( PARTITION BY pt.test_item_name ORDER BY pt.test_item_id ) row_id FROM t_procedure_test pt WHERE pt.m 阅读全文
摘要：
update A set A.COLUMN2=(select distinct(B.COLUMN2) from B where B.ID=A.ID ); 阅读全文