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
- 7244 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 |
When you found a bug and reports it to the developer but the developer is least bothered and he does not accept that bug what will u do?
11. Do you have any other questions or comments about the Web site or your experiences with it?
If there is no sufficent time for testing & u have to complete the testing then what will u do?
Can any one tell me which is the best institute for testing in Hyderabad and also the faculty suresh or nageshwarao ????
Can u specify one Deadlock or Processlock issue in a client server application?
last testcase for project will be written in which phase?
how to deploye the build when the developers give the source code..?
Give me examples for high severity and low priority defects?
Define Major defect
What is difference between windows application and Web Application?
Give proper Seq. to following testing Types Regression, Retesting, Funtional, Sanity and Performance Testing.? and which phase of STLC comes?
Hi, what is tier1.tier2.tier3 company.
Automation Testing 
