Interested to Buy Any Domain ? << Click Here >> for more details...
Hi all,
Can any one give answer for this 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.. Plz its urjent can any one give querry.. Thanks in
advance.
- 4 Answers
- 7662 Views
- JPMorgan Chase, I also Faced
- E-Mail Answers
Answer Posted / ajit
select *from addr1 where add1 is not null and add2 is null
and add3 is null or add1 is null and add2 is not null and
add3 is null or add1 is null and add2 is null
and add3 is not null
| Is This Answer Correct ? | 0 Yes | 3 No |
Post New Answer View All Answers
How to put more than 1000 values into an oracle in clause?
How to convert numbers to characters in oracle?
How do I recompile a procedure in oracle?
How to resolve name conflicts between variables and columns?
What is the best way to do multi-row insert in oracle?
Explain the use of analyse option in exp command.
How to drop an existing view in oracle?
How to convert csv to table in oracle?
Explain oracle’s system global area (sga).
How to delete multiple rows from a table in oracle?
What is a data lock in oracle?
what's query optimization and without use of IN AND Exist can we get another way data from query
What is the difference between postgresql and oracle?
How to synchronize 2 schema's objects?
HI, Please let me know the syllabus for Oracle OCA and OCP Certification
