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.
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 |
Please can any one tell me 1).Types of reports 2).Types of Meetings.
Where do you get your expected results?
write test cases on wall
you will be given a program and asked to write the Test Data and expected output for the same. for eg: there is a program which returns the sum of largest two numbers in an integer array.
In any application there are so many fields. So tester have to test each field with Special chars., Alphabetic value, Alphanumeric value, Blank Space. etc. I am testing with all these inputs but should I have to consider these into test cases. Because rather than these there many functionalities to check.Please Guide me properly
can any body tell me vat is the status of the bug when it is going for retesting and where we write the bugs in case of retesting
What are the reasons why parameterization is necessary when load testing the Web server and the database server?
Test case on Air conditionar
What is the priority in fixing the bugs? Explain the severity u rate for the bugs found?
How is your project connected to the Database...tell the procedure??
Hi ALl, Can you please list out Q & A for Test Lead,which Interviewer may ask in interview for Test Lead position
What makes a good QA or Test Manager?