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.

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


Please Help Members By Posting Answers For Below Questions

When did u complete testing ? Which scenrio should not be in automation testing ? why ?

2389


test cases on bangles???

2539


What is Dynamic Binding and Dynamic Loss?

1582


What are the phases involved in software testing life cycle?

675


What is verification in software testing?

673






what is localization and globalization.and what are the ways way are going to test the particular application?how can we identify factual, visual, corrupted characters, link errors, formatting errors, etc in locallization?iam going to attend the interview on localization concepts and languages like : German, Japanese, French, Russian, Italian, Chinese, Korean, Portuguese and Spanish .tell me the process how to do testing above concepts let me know its urgent:anilaluvala@gmail.com 9908814046

1580


how to write the test cases for mark as read/unread mails for gmail inbox?and what are the testings we will do?

6090


IN SQL SERVER 2005, With out using Query, hw can u break down USER NAME & PASSWORD to enter the software.

1721


what are the responsibilities for QA tester to test application on UNIX environment??? what skills required for unix???

1573


What is the different between SIT and UIT?

885


Hi all, can anyone tell me what is the selection procedure in Birlasoft for Manual Tester?It will be a great help.

1456


How should your staff be managed? How about your overtime?

2756


Describe your personal software development process.

2153


What is desk checking and control flow analysis

754


Hi everyone, My name is Salil Mishra. I am having 1.7 years of experience in manual testing. But as i m 2008 passout, there are limited position for me in the companies. Please help me out in getting a good job guys..I f you find something then please mail me at salilmishra29@gmail.com

1522