Suppose im having employee table with fields, eno, ename, dept, address1, address2, address3. In address field employee can fill only address1 or address2 or address3... at a time he can fill three address fields. now i want all employee names who filled only one address field..

smonroy

 Profile Answers by smonroy Questions by smonroy

• Sep 27th, 2011

SELECT ename FROM employee WHERE (address1'' OR address2'' OR address3'' )

ashok2909

 Profile Answers by ashok2909 Questions by ashok2909

• Aug 2nd, 2011

As far as i know use concatenation operator...

Code
SELECT ename AS name,address1 || ',' ||address2||','||address3 AS address FROM employee

Answer Question  Select Best Answer