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
- 6992 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
if go through 1 or 2 projects clearly,then i feel comfortable to search the job,please help me
What is bug severity?
Can you explain steps in function points?
How do you get programmers to build testability support into their code?
About Testing
iam new testing, i want improve writing test cases and bug defect etc? any on give suggestion pls?
value momentum
Zenq interview questions for manual testing
How do you scope,organise and execute a test project.
How quickly we need to fix the bug? Or how soon the bug should get fixed?
1.For a single module how many builds are possible 2.what will be the max or min time to finish up an single module
In a systen design to work out the tax to be paid: An employee has Rs 4000 of salary tax free. the next Rs 1500 is taxed at 10% , the next Rs 28000 is taxed at 22% , any further amount is taxed at 40% , the nearest whole Rs, which of these is a valid boundary value analysis test case ???? a)Rs 1500 b)Rs 32001 c)Rs 33501 d) Rs 28000.
whats the reason to display the password(not in encrypted form) in the script in load runner but not in QTP?
Can any one suggest how to write the bug reports effectively by optimizing what we want to describe?
Am putting E-commerce project in my resume can any one please tell me about E-commerce application explaination..
