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
- 7610 Views
- JPMorgan Chase, I also Faced
- E-Mail Answers
Answer Posted / babuli
select ename from emp where (address1 is not null or address2
is not null or address3 is not null) and
((address1 is null and address2 is null ) or (address1 is
null and address3 is null ) or (address2 is null and address3
is null ))
| Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
Can u please explain me the Discussion on Except ,using cast like type cast. Question in the context of difference between two tables
Give the various rollback segment states.
How many types of synonyms in Oracle?
What is a cursor variable?
Can select statements be used on views in oracle?
What is java oracle used for?
What is the difference between translate and replace?
what are actual and formal parameters?
how to handle exceptions in post production
What is an oracle function?
What is different types of joins?
What is Java Pool in Oracle?
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
What is dual table oracle?
What are the general rules on data consistency?
