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
- 7679 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
What is the recommended interval at which to run statspack snapshots, and why?
What is query image?
How to drop an index in oracle?
State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.
What privilege is needed for a user to query tables in another schema?
How to build data dictionary view an new database?
How can you use check constraints for self referential integrity?
Difference between oracle's plus (+) notation and ansi join notation?
What is Undo Management Advisor in Oracle?
What are the differences between lov and list item?
How to store only time; not date and time?
How to create an oracle testing table?
Explain the features of oracle?
What are the different types of trigger and explain its various uses and functions?
Difference between varchar and varchar2 data types?
