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
- 6999 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 |
integration test cases for mouse and keyboard
Who writes "white box " test cases ?
What is Standalone testing?
what is the use of this application?
In interview How do explain in Testcase of Calcuator,Cellphones, Email testing?
How will you divide two numbers without using the division operator?
2 Answers Aspire, College School Exams Tests,
What Tester should do after getting Requirement Doc?
Can anyone give me the example of High Priority and High severity defect. Please dont give me answers like Spelling mistakes or logo missing something like that. Give me some real time example from your application. Thanks in Advance.
What is revision history and the content of revision history table?
What might be the reasons for changing the status of a bug to " NOT A BUG " ?
Whatis the need of writing testcases? why don,t test the application without the testcases
What is the difference between Project Based Testing and Product Based Testing?
Automation Testing 
