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
- 7162 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 client give you a project then which testing you will perform first
What are similarities of Agile and Scrum?
can u plz give an example for regression testing with example.
what are all the things we will include in " what to be tested and what not to be tested" in Test Plan
Can anybody help i put the pharma and bank project in my resume, but i dont know what to tell about them, any body tell the where can i get the information about them,what i need to tell about these applications,please help me
what is functional testing terminologies
consider therez 1 land and it has mango trees in it, what are the tets cases or how will we count no of mangoes on all trees
Describe any bug you remember. Plz Give some real examples
How much the bug is affecting the functionality of the application?
how will we change the server system time?
What do you do (with the project staff) when the schedule fails?
What is the term ‘quality’ mean when testing?
Hi Friends, I wish to start my career in manual Testing as I believe I am ready to face Interviews.I have good domain knowledge in banking(investment and retail) and insurance.To be in the competition I have added three years of testing experience to my CV apart from my domain experience. Can someone please advice some real time tips which can help in facing the interview. Thanks in advance
what is a data guidelines?
what is mean by impact analysis ,how we used to select regression TC using this?
