raul

• Sep 21st, 2015

 

Code
SELECT DISTINCT T1.col1, T2.col2 FROM table T1, table T2 WHERE T1.col1 <> T2.col2 AND T1.col2 <> T2.col1

manish

• Feb 7th, 2017

 

SELECT a.mem_name,a.loc_name
FROM TAB4 a
WHERE a.loc_name <= a.mem_name
UNION
SELECT a.loc_name AS mem_name ,a.mem_name AS loc_name
FROM TAB4 a
WHERE a.loc_name >= a.mem_name;

Priyanka Jaiiswal

• Aug 17th, 2017

 

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