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
When did u complete testing ? Which scenrio should not be in automation testing ? why ?
test cases on bangles???
What is Dynamic Binding and Dynamic Loss?
What are the phases involved in software testing life cycle?
What is verification in software testing?
what is localization and globalization.and what are the ways way are going to test the particular application?how can we identify factual, visual, corrupted characters, link errors, formatting errors, etc in locallization?iam going to attend the interview on localization concepts and languages like : German, Japanese, French, Russian, Italian, Chinese, Korean, Portuguese and Spanish .tell me the process how to do testing above concepts let me know its urgent:anilaluvala@gmail.com 9908814046
how to write the test cases for mark as read/unread mails for gmail inbox?and what are the testings we will do?
IN SQL SERVER 2005, With out using Query, hw can u break down USER NAME & PASSWORD to enter the software.
what are the responsibilities for QA tester to test application on UNIX environment??? what skills required for unix???
What is the different between SIT and UIT?
Hi all, can anyone tell me what is the selection procedure in Birlasoft for Manual Tester?It will be a great help.
How should your staff be managed? How about your overtime?
Describe your personal software development process.
What is desk checking and control flow analysis
Hi everyone, My name is Salil Mishra. I am having 1.7 years of experience in manual testing. But as i m 2008 passout, there are limited position for me in the companies. Please help me out in getting a good job guys..I f you find something then please mail me at salilmishra29@gmail.com