How to delete reverse duplicate in oracle. e.g i/p col1 col2 hyd blr mum del del blr blr hyd blr del i want in o/p col1 col2 hyd blr mum del del blr

Priyanka Jaiiswal

• Aug 17th, 2017

SELECT a.col1 ,a.col2 from t1 a
where a.col1 < = a.col2

manish

• Feb 7th, 2017

SELECT a.mem_name,a.loc_name
FROM TAB4 a
WHERE a.loc_name = a.mem_name;

Answer Question  Select Best Answer