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
- 6340 Views
- JPMorgan Chase, Zenith, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / nitin sharma
select ename from employee where adress2 and adress3 is NULL;
| Is This Answer Correct ? | 5 Yes | 13 No |
what is mean by funtionality testing and performance testing,and what is the difference?
Suppose you have given a project which have less Requirement specification documents or say no specification what will your decision how will you conduct the testing.
how would u ensure 100% coverage testing?
Could any one explains what is Significans of V MOdel? Why not it is called as W model or some other X model? Is there any specifi Answer for this Qustion.
1. what are the qualities of a tester ?
what is meant by Priority and Severity?
What is the difference between smoke an sanity testing with example ?
Can you explain regression testing and confirmation testing?
i have two questions ,1)wat is sixsigmatesting 2)wat is stand alone project.plz anybody give the answer
Need to know about Quality Center in brief
Write 5 test cases for UAT of internet Banking system
2 Answers Infosys, Zycus Infotech,
What are build and version please explain why number changes in build and version
Automation Testing 
