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
- 7140 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
When we use integration testing for any new system so why we required system testing.
what is agile model and spiral maodel?pls explain with an example?
test cases on bangles???
What is difference between Bug resolution meeting & Bug Review Committee? Who are participants?
Write 2 scenarios for System testing?
can any one explain me briefly erp pharma project including all modules,like how to tell this project in interview in terms of s/w testing
What is Application Performance testing and Operational performance testing
How much the bug is affecting the functionality of the application?
Why you are selected software testing as career ?
In which all places, testing is done?One is from the server by calling server name.Can u suggest others?
what will be verification and validation test cases for yahoo login page (only functional test cases)? Please explain in details.
if go through 1 or 2 projects clearly,then i feel comfortable to search the job,please help me
What are the cases why parameterization is necessary when load testing the Web server and the database server?
Katari your questions was really helpful could you please send the questions and answers with them . Can anyone sends the top 30-40 question and answers for the interview purposes
I know functional test cases are derived from frs and system design specs. But are test cases for performance, database, boundary, relational integrity and other types of tests other than functional tests created from frs and system design specs as well? When are these test cases created? Are they in the same test plans alongside functional test cases or is their a different test plan that includes these test cases?
