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
- 6145 Views
- JPMorgan Chase, Zenith, I also Faced
- E-Mail Answers
Answer Posted / nitin sharma
select ename from employee where adress2 and adress3 is NULL;
| Is This Answer Correct ? | 5 Yes | 13 No |
Post New Answer View All Answers
Difference between adhoc testing and error guessing?
Hello all, Can someone tell me what kind of questions i can expect from hiring manager along with two team members on final face to face interview for manual testing position.. I am switching from BA to QA as its better on benefits etc.. Thanks in advance
Architectural structure of the insurance project?
In cycle 1 we have 100 test cases out of which 95 test cases are PASS and 5 test cases are FAIL. So in cycle 2 how many test cases performed as a part of regression testing?
What is integration level testing?
i have source and target having same data structure 500 fields and one lacks records. how to validate data. write 5 scenarios.
write test case for gmail sign up page?
What are the phases involved in software testing life cycle?
What does a manual tester need to become proficient with db testing?
Explain thread testing.
Explain the sub-genres of performance testing?
If asked to create a Configuration Design Pattern, where would you start?
what is diffrence between dynamic black box testing and dynamic white box testing
explain ur testing project? how can u nexplain . what should we explain ? i have not worked on any project?
how will you estimate of your website?
