hi i have table which got same data but from diffirent database in difiirent time stamp, i what to view which data is the latest,in my table i got folowing column
empno_db1,emp_no_db2,trans_date_db1,trans_date_db2,receipt_date_db1,receipt_date_db2
my goal is to see which record is the latest one and from which database, how can i approch this,sql
select empno,max(trans_date), max(receipt_date) from table@db1 group by empno
same for the db2 query.