Interested to Buy Any Domain ? << Click Here >> for more details...
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.
- 2 Answers
- 7119 Views
- JPMorgan Chase, Zenith, I also Faced
- E-Mail Answers
Answer Posted / raj
Select ename from employee
where (adress 1 is not NULL and (adress 2 and address
ISNULL)) OR (adress 2 is not NULL and (adress 1 and address
3 ISNULL)) OR (adress 3 is not NULL and (address 2 and
address 1 ISNULL))
| Is This Answer Correct ? | 29 Yes | 0 No |
Post New Answer View All Answers
Want to learn Manual Testing in just two days? Students around Thanjavur, Trichy, Mayavaram and Kumbakonam Mail to manualtestingtraning@gmail.com. Entire Manual Testing Concept. Any doubt regarding IT Job please mail above ID
What is difference between web site testing, desktop application testing and wireless application testing? what is the difference in testing strategy to test them?
What knowledge I must have as a 3 yrs. manual tester??
what is test case management?explain in brief.
What are the benefits of requirement traceability?
What is the test case?
Hi,all i have a desktop App. which have a feature, It's a demo version if u want full version then u have to perches it. Pls give me some idea ASAP how can i break the App.
What is benchmark testing? hi friends... can anyone suggest the correct answer plz...
How do you test google or gmail application??tell me step by step process??
What is difference between V-Model and Agile Model?
How to do integration testing on duster......
After insert the record in front-end, how will you check the back end by manually? Please explain?
what are metrics and what are metrics did u collect in you are project
Where we have to use perl scripting in Testing approach and its importance
How we allocate the priority(Blocker, Critical, etc.,) in Testing?
