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
- 7807 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 is memory advisor in Oracle?
what is IDE,DMV in sql server?
What is query image?
How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?
What are the parameters that we can pass through a stored procedure?
how to join query for one source type is oracle another source type is sql server ?
What to do if the startbd.bat failed to start the xe instance?
How to find the duplicate rows count from employees table in oracle?
What the is the diff between local index and global index. give some example.
How to add another datafile to a tablespace?
Hi friends can u send the oracle 9i full version download link?????????????? please reply ?
How to use "startup" command to start default instance?
What is the difference between formal parameters and actual parameters?
Explain what are the characteristics of data files?
How do I spool to a csv formatted file using sqlplus?
