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
- 7602 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
What privilege is needed for a user to delete rows from tables in another schema?
Explain enable novalidate constraint.
Can we store images in oracle database?
Is it possible to set second Primary Key Constraint in a table in Oracle Database ?
What is the maximum number of triggers that can be applied to a single table?
How to enter a new row into a table interactively?
What is PL/SQL ?
What are a cluster and non-cluster index?
What is the usage of synonyms?
How to get a create statement for an existing table?
State the difference between a primary key and foreign key?
What is the data pump export utility?
What are dml statements in oracle?
How to use "for" statements in oracle?
How to store only time; not date and time?
