Employee Query question

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..

Shashipal Reddy
Profile Answers by Shashipal Reddy Questions by Shashipal Reddy
May 9th, 2011
7
4522

Questions by Shashipal Reddy

SQL

Answer

Showing Answers 1 - 7 of 7 Answers

Vasavi Katakam
Profile Answers by Vasavi Katakam

Jul 19th, 2011

Code
 


SELECT * FROM employee WHERE 


(address1 LIKE '%' AND address2 LIKE ' '


 AND address3 LIKE ' ') 


OR (address1 LIKE ' ' 


AND address2 LIKE '%' 


AND address3 LIKE ' ') 


OR (address1 LIKE ' ' 


AND address2 LIKE ' ' AND address3 LIKE '%')

ashok2909
Profile Answers by ashok2909

Aug 1st, 2011
As far as i know use concatenation operator...
Code
SELECT ename AS name,address1 || ',' ||address2||','||address3 AS address FROM employee