hi i have a table which got duplicate column
empno_db1
empno_db2
i what to write a query which will return value
when empno_db1 <> empno_db2
table script
create table empt(empno_db1 number(6),
empno_db2 number(6),
deptno_db1 varchar(30),
depatno_db2 varchar(30),
transDate_db1 date,
transDate_db2 date,
receiptdate_db1 date,
receiptdate_db2 date)
value in table
empno_db1 empno_db2 deptno_db1 depatno_db2 transDate_db1 transDate_db2 receiptdate_db1 receiptdate_db2
001 001 100 100 11/12/2015 11/12/2015 12/12/2015 12/12/2015
002 002 001 002 13/12/2015 09/12/2015 12/12/2015 12/12/2015
i only what to return value like this
empno_db1 empno_db2 deptno_db1 depatno_db2 transDate_db1 transDate_db2 receiptdate_db1 receiptdate_db2
002 002 001 002 13/12/2015 09/12/2015 12/12/2015 12/12/2015
lets say there is 50 000 records