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
- 7032 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
user id @ yahoo.com (or) yahoo.co.in (or) gmail.com.... etc
How can you define state tanstion testing aswell decesion testing with examples.how you can differ them too??
What is big bang approach?
what could be the (realtime)bugs you come across in job portal and health care projects in terms of 1. high severity n low priority 2. high severity n high priority 3. low severity n low priority 4. low severity n low priority? pls its very urgent thanks n in advance n lukin forward for reply
How to write test cases for nevigating menus? Ex. Course -Topics -Subtopics
About Testing
can anyone help me in getting unix on manual testing i.e can u forward material & web sites to my mail id (suresh_57599@yahoo.com) to understand how the work flow working on manual testing on unix and the contents.plzzzzzzzz help me its urgent.
write test case for gmail sign up page?
What is sanity?
how to generate id in testdirector? a) Td id 1 b) td id 2 c) td id 3 d) td id 4 which is correct answer please any one of the tell me and mail me
14.What is function point breakdown?
plz send the test scenarios and test cases for "user name should contain 4 to 8 chars and they should have only vowels"
What is user acceptance testing (uat)?
What is the Jar file?
ANY ONE HAS ATTENDED THE INTERVIEW FOR WIT INNOVATION P LTD? THEN KINDLY LET ME KNOW ABOUT THE INTERVIEW PROCESS AND QUESTIONS ASKED.
