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
- 6117 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
Write 2 scenarios for System testing?
Hi Friends, I want to know the best institute in hyderabad which is giving training in 'SAP Testing' and who is the best faculty. Regards, Imtiyaz..
Hi Friends, Just One Month Back I was Join in Small Company as a Testing Eng.I have Six Month Exp. In this Company all my team memb.r fresher & PM give responsibility on us to prepare all require QC doc. for our new project.So I need ur help in this matter .How Can I start my work and Which Doc.I start to collect & From Where I get Detail Information all abt these thing. Thanks to all friends who give reply to this. Suyog
Relative to other technical groups in the company? Relative to your staff?
how many modules in ur bank project? what functionalities r there?how did u check? could u plz expalin ur banking project?
List out test deliverables?
What if an organization is growing so fast that fixed testing processes are impossible? What to do in such situations?
why testcases are written and what is the importance?
What if the project isn’t big enough to justify extensive testing?
what are the risks and contingencies u had in ur project?
Hi could some one please send me the testplan testcases(for 2Modules) and testscripts for mercry fliht aplication or gmail. please write those on templates and send me.In testplan plase write Testobjective, test scope, est approach, exlusions assumptios.
Can any one give a summary of testing a territory management system? what would be the test scenarios, few test cases. how it works.
List the type of testing perform to test microsoft excel 2003 give atleast 1 example of each type
in the account there is 10,000 rupees and i entered 20000, in this case how will you test the application
can anyone tell me the questions that can be posed in an interview for a 5 year experienced person in manual testing
