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.
Answer Posted / nitin sharma
select ename from employee where adress2 and adress3 is NULL;
| Is This Answer Correct ? | 5 Yes | 13 No |
Post New Answer View All Answers
online demo for bug tracker tool(let me know the website)
is it not possible to automate full project??what r the parts in project that cant be automated(tht has to be done manually)?
What is the difference between manual testing and automation testing?
Hi ALl, Can you please list out Q & A for Test Lead,which Interviewer may ask in interview for Test Lead position
can any one send sample test cases for database testing by taking an example? also leave emailid please. thanks (very urgent)
What are the types of maintenance?
Test approach to windows update?
When we are recording in WinRunner and interact with the AUT, what does WinRunner do?
How does compatibility testing differ while testing in Internet explorer and testing in Firefox?
I have 2 yrs 10 months experience in manual testing. there is a gap of 3 yrs in between. just 3 months before i rejoined the same company. I am looking for new & better job.What I have to enhance my career to up level, should I have to do Automation course or any other. Guide me properly.
why QA team is necessary for an organization?
What makes a good software qa engineer?
What is a critical bug?
What is build interval period?
diff b/w desktop based testing & web application testing